I have a 'single line of text column' and a calculated column. When I am adding reference of the 'single line of text' column to calculated column it gives me error of
One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. for test column
There are other 'single line of text' columns that I am able to use in my calculated column. This error is for only one column. Has the column got corrupted in any way? Also the internal name and display name of the column is different. Can that be source of problem?
Update 1: The formula that I am using is pretty simple =[Approval Status]
. That's it. The column [Approval Status]
is a 'single line of text' type column, though its internal name is different. Using this formula itself it shows error.