I have a site column Construction - Complete Date which is used by my calculated column Construction - Is Complete?. Whenever a date is entered for the Construction - Complete Date then Construction - Is Complete? should be equal to "Yes" otherwise it is "No".
My calculated column formula reads as below:
=IF(ISBLANK([Construction - Complete Date]),"No","Yes")
However, when I save the calculated column and check my existing rows the calculation is not being done correctly. When I go back to my calculated column the formula has changed to this:
I've read in this blog article that it is a problem for site columns but not for list columns and that the solution is to change the name and remove the "-". However, I need to keep it as a site column because it is used by multiple content types and I use the "-" convention to group common fields that are all for the same list entry. Is there an alternative option where I could keep the name and get the calculated column to work?