Forum Discussion

Black_Square's avatar
Black_Square
Copper Contributor
Aug 26, 2024

Struggling with Calculated Columns (Beginner)

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!

SharePoint Online

1 Reply

Sort By
  • michalkornet's avatar
    michalkornet
    Iron Contributor
    Aug 31, 2024

    Hi Black_Square, unfortunately, the lookup column is not supported in calculated columns. I guess this column should not be available to choose from the list of available columns when creating a formula.

     

    This formula should give you an error:

     =[Consultant ID]

     

    And this one should work:

    =TEXT([Proposal Date],"dd/MM/yyyy") & "-"

     

    Can you maybe use a Power Automate flow to create the desired value?

Resources