Hi,
I am new to Grist and its my first post.
I am having a status field which moves to next status based on the values filled up in other columns and an action button on that column. Since Grist is excel based it would be better to be able to fill up all columns in corresponding rows and then have an action button which is able to update the status column in all these rows where the condition is satisfied.
Eg: Status is A and if Value in column X is empty or null on action nothing happens but if value of column X is True then action moves Status to B. I am able to do this for each row individually. I want to be able to do this for all rows where the above condition is true.
Please help and guide.