Date Column - if, then, else

Copper Contributor

I want to add a File Expiry date on documents only. In other words, if Content Type is a Folder, then File Expiration should equal Last Modified date. Otherwise File Expirations should be Last Modified + 90 days. 


I am new to SharePoint - but in my mind, the following makes sense, but of course it is not working.


if [Content Type]='Folder',[Last Modified], [Last Modified]+90


Thank you

1 Reply



Using Content Type Column in Calculated Column Formula is not supported.


Here only possible approach to set Expiration Date using Power Automate.


Reference Link: 


Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community