Automations

Cemil Binlik

Hi,

I have below automations set for a sheet that gets the values from another sheet by index(match) function, and that another sheet is being updated on a daily basis.

As can be seen in this example, I'm trying to get only the newly received SOWs but couldn't quite manage to do it. I tried almost everything in the conditions section, but I keep receiving the all sites as NTP received in the automated reports.

Any chance you can tell me where I'm doing wrong?

che.rabajante

Hello @Cemil Binlik

Does this have a form or direct input of data in spreadsheet?

I suggest to add Status column with dropdown values (New, In Progress, Completed)

Then in Automation, newly added row will be tagged "New" in Status column and add condition that you will received only SOW if Status is "New"

Hope this helps😊

Ella

@Cemil Binlik Try by changing your trigger to "When rows are added" only.

Cemil Binlik

@Ella this could help I guess, let me try