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

Options

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

Attachments not included in email alerts (automation)
Is anyone else experiencing this issue? When I set up an automation to alert someone by email and choose the “link to sheet and specific fields” option, I do make sure to include the attachment field in the selected fields. However, even though the row has an attachment, it doesn’t carry over into the email. That said,…
Automate an attachment to email to requestor
I have a form where, based on data selected a form will automatically be sent to the requestor. In this instance if work is being done outside NYS , then I want the automation to send a file once I receive the alert that it's there, asking to have it completed and emailed back to. So basically when someone submits the form…
Are Automations the BEST WAY to clear a sheet before a Bridge Workflow is run?
I've seen various ideas on how to clear a sheet using bridge before beginning a workflow. However, could it be as simple as this?: Add a checkbox column such as "Delete Row" Use Bridge to change all rows to be removed using an "update sheet" in Bridge. Use automation to move rows out when the row is checked instead of a…

woman with hands out and open

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

Watch video<