Hi guys,

I really hope you can help with this as this is driving me mad!

I have a list called Project Budgets. The purpose of this list is to identify consultants using a Consultant ID column (look-up column) and the date of their fee proposal using a Proposal Date column (date column). I would then like to join this data together to create the data for the next column in the row titled Budget ID.

So, as an example working across one row of data: 001FROS (Consultant ID), 24/11/2023 (Proposal Date), 24/11/2023-001FROS (Budget ID).

To try and achieve the above this is the formula I am using:

 =TEXT([Proposal Date],”dd/MM/yyyy”) & “-” & [Consultant ID]

However, I keep getting this error message: One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas.

What am I doing wrong? 

Thank you!

​Hi guys, I really hope you can help with this as this is driving me mad! I have a list called Project Budgets. The purpose of this list is to identify consultants using a Consultant ID column (look-up column) and the date of their fee proposal using a Proposal Date column (date column). I would then like to join this data together to create the data for the next column in the row titled Budget ID. So, as an example working across one row of data: 001FROS (Consultant ID), 24/11/2023 (Proposal Date), 24/11/2023-001FROS (Budget ID). To try and achieve the above this is the formula I am using:  =TEXT([Proposal Date],”dd/MM/yyyy”) & “-” & [Consultant ID] However, I keep getting this error message: One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. What am I doing wrong?  Thank you!  Read More

​