Forum Discussion
Shah1827
Jul 03, 2020Copper Contributor
Sharepoint formula problem
Hello Everyone, As I am trying to add calculated column it is showing error. For going in details please find attachments. Regards, Sagar Shah
racrig
Jul 06, 2020Brass Contributor
Shah1827 Not sure what you are trying to calculate, but here are some references for sharepoint calculated columns:
https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3
https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-2010/bb862071(v=office.14)
https://natechamberlain.com/2018/08/27/extract-date-components-using-the-text-function-in-sharepoint-calculated-columns/
But yes, your column must be of type "Calculated" if you want a value derived from a formula. It can't be Single Line of Text.