79640320

Date: 2025-05-27 10:56:21
Score: 0.5
Natty:
Report link

You need to use an IF statement as part of your formula to check if the value in column D is blank

The below would be the formula to be added into column H. The if(D2=closed, "" is checking if D2 equals Closed and if it does, is entering a blank value.

=IF(D2="Closed","",(TODAY()-G2)&" "&"Days")
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: A.Steer