Is there a way to request sign-off/ approval for only certain rows in a sheet?

Alicia D

I am trying to create an option where all of the rows under PressRoom Action Items require a sign off or approval. I tried to do automation for this but I couldn't find a way to make it just for those particular rows. Is there another way? I also thought about forms but it didn't seem to make sense for what I am doing. Thank you!

ericncarr

Hi @Alicia D,

I would add a helper column that is a checkbox with a formula like this:

=if(parent(Task@row) = "Pressroom Action Items", 1, 0)

This box will only check for rows that are beneath "Pressroom Action Items", allowing you to have a condition in automation that only runs if that helper column is checked.