Using Tomorrow in date filters

Chris White

Hi,

We have a SmartSheet that has several systems and their respective go live dates as columns. I am trying to create a filter that will show which systems are going live tomorrow for our infrastructure team.

If I use the filter option "is in the next (days)" = 1 then it shows both today and tomorrow. I am unable to use the combination of "is in the next (days)" = 1 and "is not today" since I need the match condition to be set to "at least one condition" since we are looking at several columns of data.

Any thoughts would be greatly appreciated!

Paul Newcome

I would suggest a helper checkbox column that checks the box on each row if any one of those dates equals tomorrow. THen you can filter off of the box being checked.

=IF(OR([LevelUp Upgrade Install Date]@row = TODAY(1), [Omnivore Agent Go Live]@row = TODAY(1), [Potmates Go Live]@row = TODAY(1), [Uber Eats Go Live]@row = TODAY(1), [Aloha Upgrade]@row = TODAY(1)), 1)

Paul Newcome

I would suggest a helper checkbox column that checks the box on each row if any one of those dates equals tomorrow. THen you can filter off of the box being checked.

=IF(OR([LevelUp Upgrade Install Date]@row = TODAY(1), [Omnivore Agent Go Live]@row = TODAY(1), [Potmates Go Live]@row = TODAY(1), [Uber Eats Go Live]@row = TODAY(1), [Aloha Upgrade]@row = TODAY(1)), 1)

Chris White

Thanks, I hadn't thought of doing that. I will give it a shot!

Paul Newcome

Happy to help. 👍️