Date Column - if, then, else

[KEsiemens]

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

[#2]

@KEsiemens 

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

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

Reference Link: https://www.c-sharpcorner.com/blogs/when-an-item-or-file-is-modified-trigger-for-sharepoint-connecto... 

---

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