Hi,
I am creating a new row in Smartsheet based on a trigger that is functioning properly.
What I would like to do is this:
Update the NEW row with a date that is 14 days from the updated row’s date.
For example: When the updated row has a date column that says 03/18/2022, the NEW row I am adding should say 04/01/2022.
I have tried searching for answers with no success (probably just bad search terms).
I appreciate any help.