Automation for Changing Project Status if Start Date = Today

I’m trying to create an automation that will change the status of a row (i.e., a project in a table of tracked projects) ONLY IF today’s date matches the start date of the project.

Here’s what I’ve tried so far:

Hi Rai! It looks like you’re checking if the whole column, which is a list of dates, equals today, which it never will :frowning:

Try something like this instead, while leaving the if part blank:

[Current Projects].Filter([Start Date] = Today()).ModifyRows(Status, [In Progress])

The filter will give you a list of rows which start date equals today, you can then modify all these rows at once

p.s. In the loom you set it to weekly, not daily :slight_smile:


Thank you so much! That worked!

1 Like

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