Set column value dynamically in automation

Hello -

I’m using Automation to duplicate rows, but I’m having a hard time dynamically setting a column value. I’ve got a column called date that I would like to populate to today()+7 days (next week), but it appears the “Update Values” part of Automation only takes static values?

image

You are so close!

The part where you input the value you want to pass to date can take static or dynamic values

To pass it a dynamic value, simply click in the box and press the = sign. that will open the formula editor and allow you to input any formula constructed value you want

Thanks!!

Clearly new to this :slight_smile:

1 Like