nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Count number of days if status is "Open"

Raman Oto

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!

Smartsheet Formula.JPG

Find more posts tagged with

Solution Center

Comments

Nic Larsen

Try this:

=IF([Status]@row = "Open", TODAY() - [Created Date]@row, "")

Raman Oto

Perfect! That works. Thank you so much Nic!

Sign in to join the conversation!

Quick Links

Trending discussions

Data is missing
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Users incorrectly labelled as "External"
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…