Help

Discover what data silos are costing your org in our commissioned Forrester study. Learn more

Change the date - For a resubmission

Topic Labels: Automations
Solved
Jump to Solution
87 2
cancel
Showing results for 
Search instead for 
Did you mean: 

I would like to replace the date in the field “date” by date +5 days as soon as it is today.

what I have tried so far:
My first formula [Called: Formular1]:

IF(IS_SAME(date,NOW(),'MINUTE'), "Now")

The Second Formular [Called: RepeatCalculation]

DATEADD(date, 5, 'week')

Next, I attempted to set up an automation:
Trigger: “When a record matches conditions” when Formula1 is “Now”
Action: “Update record” Record ID “date”
When chosing Field i can not select my [RepeatCalculation]Formula.

  • The following error message appears
    chrome_WxpCXFF1cO

I think I have missed something. I am grateful for any help.
Sorry: English is not my mother tongue

1 Solution

Accepted Solutions

Hi Boris, I’m not too sure why that’s happening. I’ve set up a base here with the automation you’re trying to do and it seems to work fine. Perhaps you can compare the two to see what the differences are

See Solution in Thread

2 Replies 2

Hi Boris, I’m not too sure why that’s happening. I’ve set up a base here with the automation you’re trying to do and it seems to work fine. Perhaps you can compare the two to see what the differences are

Hi Adam, Thank you very much for taking the time to look into my question. The example you created helped me a lot. I have made a mistake with the RecordID. Thanks much for sharing your insight.