Please have all columns types compatible with Calculated and validation
Actually, only few columns types are usable by Calculated columns and Columns Validation. It would be EXTREMELY convenient if we could use:
-Managed Metadata (Text)
-Managed Metadata (Term-ID)
-Multiple lines of text
-Item ID (current Item)
-Document Name (current Document)
-Yes/No (check box)
It would be also great if there was an option to format calculated column as HTML (for now only text, date, number)
Another column that should definitely be usable for column calculation and validation is "Content Type". For example, I should be able to calculate values depending on whether the item has my custom content types "Purchase Contract" or "Invoice", etc.
J Bedford commented
It's hard to believe this is still not possible in 2020.
We are using SharePoint Online, and really miss being able to add HTML to calculated columns. How else are we meant to create status indicators in lists? I'm out of votes but I fully support this idea!
Tony GH commented
FYI - There is already a workaround for calculated hyperlinks/HTML but Microsoft has removed it in the latest SharePoint upgrade, e.g. on Office 365.
Please see the following UserVoice suggestion for details, and help up-vote it, too?