Forum Discussion
Solved
Calculated column for a Sharepoint list
Good Afternoon all, I need some help calculating a coulmn on sharepoint and was hoping some super users could help. What I would like to do is a calculated column, im using 4 columns to calcula...
Keegan960 Try something like this for your calculated column formula:
=IF(OR(AND([Finding type]="Minor",[Internal External]="Internal",ISBLANK([Containment]),(TODAY()-[Created])>5),AND([Finding type]="Major",[Internal External]="Internal",ISBLANK([Containment]),(TODAY()-[Created])>1)),"Overdue","")Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
Keegan960 Try something like this for your calculated column formula:
=IF(OR(AND([Finding type]="Minor",[Internal External]="Internal",ISBLANK([Containment]),(TODAY()-[Created])>5),AND([Finding type]="Major",[Internal External]="Internal",ISBLANK([Containment]),(TODAY()-[Created])>1)),"Overdue","")
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs
Hello Ganeshanap,
The formula worked 1st time, amazing!!!
Thank you so much!!!
The formula worked 1st time, amazing!!!
Thank you so much!!!