Hello,
I'd like to count the number of days from created date to today only if the status of a ticket is "Open". If it's "Closed" I'd like it blank, I'm not sure how to do this.
Here is an image of the ideal results
Thanks!
Try this:
=IF([Status]@row = "Open", TODAY() - [Created Date]@row, "")
Perfect! That works. Thank you so much Nic!
I was given editing permissions this morning but when I open the sheet it still says I am View Only.
Hi I'm trying to make indent for 78 groups, is there a way to make it in one click or I need to do it one by one. see image below, e.g., I want contioue up to B-78, and that takes a lot f time. Any suggestion?
Hello, I’m writing to request assistance regarding automation notification emails in Smartsheet. Issue: I have an automation set up to notify people when I need jobs scheduled. However, instead of sending a separate email for each job/row, Smartsheet combines multiple notifications into a single, grouped email. This makes…
