Set column value dynamically in automation

1

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

2

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

3

Thanks!!

Clearly new to this :slight_smile:

1 Like
4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.