Formula / Automation inquiry

System

This discussion was created from comments split from:

Using SmartSheets to ping an alert 3 weeks prior to due date

.

GALANTI PTY LTD

Hi Support Team/Community,

What is the command to use when I need to set a date 3 weeks prior to a date in another column?

For example:

I need Due date for Jobs to be 3 weeks prior to Install date column:

I want the date to appear and change if install date changes.

Thank you

Kind Regards,

Mia Galanti

Michael Drayton

Hello Friend! since the invention of databases (think the Romans), "weeks" have been a source of stress and debate. What I can help you achieve is either 21 days or or 15 work days.

in your due date column place one or the other of these two formulas:
=[Install Date]@row - 21
=WORKDAY([Install Date]@row, -15)

Trigger: When Date is Reached
When: [Due Date For Job]
Select an Action: ???

Let me know if that works. Good Luck!

Marcela

Hello, @GALANTI PTY LTD.

Just @mentioning you in case you missed the response above!