Help with days remaining counter formula

sriccobono

Hello,

I am having an issue where if a date is entered in the 'submitted' column, the counter does not go away. I would like the 'days remaining' counter to stop if the 'submitted' column is populated:

=IF(ISBLANK([GWS-09 Submitted]@row), [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY(), IF([GWS-09 Due (within 60 days of Abandonment)]@row - TODAY() < 0, "", [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY()))

Will Jeffords

Hi @sriccobono,

Try inverting the last part of your formula to position the "then" part of the IF as follows:

=IF(ISBLANK([GWS-09 Submitted]@row), [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY(), IF([GWS-09 Due (within 60 days of Abandonment)]@row - TODAY() >= 0, [GWS-09 Due (within 60 days of Abandonment)]@row - TODAY(),""))

I'm posting this before I test it, but I think this might be the issue. I will test in a bit myself.

Cheers,

Will