Forum Discussion

Altonga's avatar
Altonga
Copper Contributor
Feb 24, 2023
Solved

Set Column Formula to work before a certain date.

Hi all,    relatively new to all this and looking to get a help in hand if possible with a formula I've been working on. I've created an IF statement to add up 6 separate columns, please see below:...
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Feb 24, 2023

    Altonga Try using formula in this format: 

     

    =IF([jDATE]<=Date(2023,2,10),IF([jBDocs],1,0)+IF([jBFaultDiag],1,0)+IF([jBFuncTest],1,0)+IF([jBRecovery],1,0)+IF([jBRects],1,0)+IF([jBTask1],1,0),IF([jBScenario1],1,0)+IF([jBScenario2],1,0)+IF([jBScenario3],1,0)+IF([jBTask1],1,0)+IF([jBTask1],1,0))

     

    You can change <= condition in above formula as per your requirements.

    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

Altonga's avatar
Altonga
Copper Contributor
Feb 24, 2023
Brilliant stuff thank you, worked so well!
ganeshsanap's avatar
ganeshsanap
MVP
Feb 24, 2023

Altonga You're welcome! Glad it worked for you.

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

Resources