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]:
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.
I think I have missed something. I am grateful for any help.
Sorry: English is not my mother tongue
Solved! Go to Solution.
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.