Forum Discussion
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...
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?