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

Setting up the welcome and help screens.
Hello All, I am having difficulties uploading my information to the welcome and help screens. We are a Micro Soft 365 shop, using share point, and I am getting the error message that share point in refusing to connect. Whereas this appears to be a share point issue; I have reached out to our IT Department, and we cannot…
logos from other companies appearing in approval and update request emails?
Is anyone else experiencing an issue where logos from other companies are being included in the email notifications from approval and update request automations? Yesterday, we noticed that our approval request and update request emails are showing company logos from other organizations rather than either our own logo, or…
RAID Log for Program
Hi All, I’m looking for some ideas and suggestions regarding RAID logs. I currently manage a portfolio of 18 projects and would like to align each individual RAID log with a program-level dashboard. Does anyone have a RAID log template they’d be willing to share? Additionally, I’d appreciate any guidance on how to…