I am experiencing a couple of problems with calculated field in document library.
Problem one: Calculated field gives me this error: The formula refers to a column that does not exist. Check the formula for spelling mistakes or change the non-existing column to an existing column.
What's the reason for this? I changed the name of the columns 4 days ago, can this be the reason for the problem i am experiencing? For example because of cache? If yes: how to flush cache in SharePoint online?
Problem two: One of the calculated field are suppose to look like this:
=[metadata1]&"-"&[Metadata2]&"-"&[ID]
, but... for some reason the brackets disappears sporadically! Anyone have a clue what the reason for this is - and how to resolve?