Forum Discussion

Aqua-holic's avatar
Aqua-holic
Copper Contributor
Aug 22, 2022

Non-developer here, how do I write SharePoint Calculations for:

  1. I am counting number of days a project is On Hold (a yes/no column) with calculated column:
    Hold Days =DATEDIF([Hold Begin Date],TODAY(),"d")
    My question - When project is not On Hold, I want "d" to display "0" 
  2. Continuing the story above, when the Hold End Date is selected the Hold Days should only display the total days between Hold Begin Date and Hold End Date (right now it still accumulates days). 

Some background, I'm a writer rarely an excel user or formula developer. Please, explain what to do and why so I learn; looks like I may be "writing" more formulas (or begging for your help!).

Thank you so, so much!

 

Resources