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

Checking multiple sheets for duplicates
Hi, I have a workspace that is being used for uploading new information by a group of techs. This information is checked and then uploaded a database by another team. Currently, I have the sheet working to check duplicates within one sheet, but once the data is uploaded to the database the line is moved to another…
Can you create email notifications on several different cells in a single column
Good morning, My project team asked me to create an inventory smartsheet. They are requesting email notifications for a single column, but for different inventory amounts on each cell. Is this possible??
Using COUNTIFS with CONTAINS as a Criterion
I have a multi select list column in Sheet 1, containing campuses. In sheet two I am trying to get a count of how many times each campus is listed in the campus column in sheet 1. Here is my current formula: =COUNTIFS({Event Campus}, CONTAINS("Cypress", {Event Campus})) The results are always "0" for each campus. Given…