Adding dates to each column

Safehavensussex

Safehavensussex ✭

06/05/24 edited 06/06/24 in Formulas and Functions

Hello,

I wonder if you can help me - I have a column with a date in it, and the following column I would like it to add how many days it has been since that date.

Does anyone know the formula for this?

Thank you

0 ·

Answers

Itai Perez ✭✭✭✭✭✭

06/05/24

Hi @Safehavensussex
Have you tried =Today()-date

Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
0 · 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

Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…
Holiday exclusion in a Workday formula
I am trying to write a formula using the workday function that excludes certain holiday. is there a way to have it know the holiday(s) without putting in the actual date? Otherwise, every year I will have to update the formula with each holiday's new date. Here is an example of what I am currently using:…
Can anyone tell me what's wrong with my formula?
I'm trying to set up a project plan that has color indicators for the timeline: RED=past due, Yellow=due in the next 5 days, Green=due in the next 14 days, Blue=due later. =IF([Due Date]2 < TODAY(), "Red", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 < TODAY(+5))), "Yellow", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 <…