Survey results (and what's coming next)
Thank you all for giving us your feedback in the recent Smartsheet Community survey! Based on your thoughts, we're excited to announce that we have many changes coming in just a few weeks. Read our survey recap post for more details.
Answers
I got it working. Thanks so much Paul for all your assistance and activity with the Smartsheet community.
Any last thoughts on how to structure the formula for >
Happy to help. 👍️
And sorry, but I am not sure exactly what you are asking in that last question...
thinkspi.com
Sorry, the end of my sentence must have got deleted somehow when I clicked submit. Wondering your thoughts on the formula for greater than 90 days old. I attempted the formula below but that did not work.
=COUNTIFS(Completed:Completed, AND(@cell >= TODAY(-91)))
Try thinking of dates as numbers where today is zero, tomorrow is one and yesterday is negative one. If you think about it that way, then what you are trying to accomplish is counting dates that are less than (today - 90 days).
=COUNTIFS(Completed:Completed, @cell <= TODAY(-91))
thinkspi.com
Thanks again Paul! Is the any useful tools in troubleshooting formulas?
I use these two quite a bit when troubleshooting:
thinkspi.com