Special formula in automation email alert

SmartsheetRookie ✭✭

05/24/22 edited 05/24/22 in Smartsheet Basics

Hi,

Is it possible to use a formula in the automation email body alert?

I need:

To add "60 days from {{Date}}" (in a formula).

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Paul H ✭✭✭✭✭✭

  05/24/22 Answer ✓

  No its not possible

  Create another column in your sheet called "Date60", use a column formula =Date@row + 60

  Use {{Date60}} in your Automation.

  0 · Share on FacebookShare on Twitter

Answers

• 

  Paul H ✭✭✭✭✭✭

  05/24/22 Answer ✓

  No its not possible

  Create another column in your sheet called "Date60", use a column formula =Date@row + 60

  Use {{Date60}} in your Automation.

  0 · Share on FacebookShare on Twitter
• 

  SmartsheetRookie ✭✭

  05/24/22

  https://community.smartsheet.com/discussion/comment/330871#Comment_330871

  Thanks!

  0 · Share on FacebookShare on Twitter