Formula Help - Countdown

Aaron Minogue

Aaron Minogue ✭

02/04/25 in Formulas and Functions

Looking for assistance on a formula that calculates the days remaining from the current date to the expiration date - any ideas?

0 ·

Best Answer

Mark.poole Community Champion

02/04/25 Answer ✓

@Aaron Minogue
This is a fairly simple formula.

=[FORS Expiry Date]@row - TODAY()

If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
1 · Share on Facebook Share on Twitter

Answers

Mark.poole Community Champion

02/04/25 Answer ✓

@Aaron Minogue
This is a fairly simple formula.

=[FORS Expiry Date]@row - TODAY()

If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
1 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Workday is not omitting the holidays?
I have tested this manually, as well as outside of my formulas. I want to reference a date, and then search on the Holidays range (a list of holidays) and return the previous workday if the date is found in the holiday list. The formula ALWAYS returns the day before the date, whether it's in the holiday list or not. Any…
I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…
Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.