How do I populate time lapse from a date enter in another column and have it caluculated in mo & yrs

LFrey036

LFrey036 ✭

05/22/24 in Smartsheet Basics

I am trying to make a column that automatically calculates a time lapse based on a date entered in a different column. I would prefer it to display in months and years if possible.

0 ·

Answers

LFrey036 ✭

05/22/24

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Automation Question
Hi. Is it possible to use the Trigger "When rows are added or changed" with a Run workflow other than "When Triggered"? I would like to send one notification daily (or weekly) to include all the updates. Thank you!
Rollup a row from any of our projects to a Unified Sheet
I would like to add a helper column to our projects and if that column has a checkmark in the column - copy the entire row to another created- central project sheet so that I can view it as a Calendar View of major tasks. So each respective PM can select a row that is worthy of rolling up to show this in the Unified…
Automation
When a cell is blank or N/A, I want another cell in a different column to show "Non-Serially Managed" How do I set this up?

Help shape the future of Smartsheet.
Share your ideas and feature requests.