CarolMcconnell
7 years agoQrew Captain
Formula Number Duration
I have this formula in a Number formula field. The Total pending first open is a numeric field because it combines two durations fields together. I can't get this to work. The formula returns nothing. What am I doing wrong?
If (IsNull ([Date Closed]),ToDays(Today()-[NWS Date Received])-[Total pending First Open],ToDays([Date Closed]-[NWS Date Received])-[Total pending First Open])
If (IsNull ([Date Closed]),ToDays(Today()-[NWS Date Received])-[Total pending First Open],ToDays([Date Closed]-[NWS Date Received])-[Total pending First Open])