Changing the question

Joe Suh

Third time lucky.. editing this post (lets go by the ordering of column 1 , 2 , 3 , 4)

How would I formulate to achieve:

• When there is no date in Column 2 I would like Column 4 to continue counting
• But, once Column 2 has a date entry in it, I would like Column 4 to stop the count on that point

is this possible ?

Mike Wilday

This formula should do it for you.

=IF(ISBlank([Date Resolved@row), Today() - [Date of Incident]@row, [Date Resolved]@row - [Date of Incident]@row)

Mike Wilday

Awesome. Glad I could be of help. Please accept my answer if it met your needs! Have a good one. Happy Smartsheeting.

Mike Wilday

That will require a third-party plugin. Zapier could handle that but it can get pretty costly.

Joe Suh

Hi Mike,

thanks again for replying... I have updated my question AGAIN!

https://answers.microsoft.com/en-us/msoffice/forum/all/stopping-a-count-of-days-when-a-date-is-entered/57ce1c77-fc44-4249-b3bb-4acc3382b0d9

this may give you an idea (something that's happening in the parallel universe)

Mike Wilday

This formula should do it for you.

=IF(ISBlank([Date Resolved@row), Today() - [Date of Incident]@row, [Date Resolved]@row - [Date of Incident]@row)

Joe Suh

Mike Mike Mike...

You legend..... I'd shout you a beer mate!

With your help I've been able to achieve something better

By removing the other half of your formula... I got what I was looking for!!!

=IF(ISBlank([Date Resolved]@row), Today() - [Date of Incident]@row

Using this allows our sheet to show the [Days Taken] when [Date resolved] is entered,

However! if there is NO [Date resolved], the [Days Open] continues counting!!!

I'm sure MANY MANY office people like me will dig this formula

Thanks again!

Mike Wilday

Awesome. Glad I could be of help. Please accept my answer if it met your needs! Have a good one. Happy Smartsheeting.