Approve All Button

I am trying to create a column formula that will change all the rows that have information in it to approved if one box on the top is checked. It is like an "Approve All" button that will let you approve all rows without having to individually check each box when its approved.

I used this formula: =IF($[Approve All]$1 = 1, "Yes", "") but it is an absolute reference and wont let me convert to a column formula.

Let me know what ideas you have, whether it be a formula, automation, etc.

Thank you!

Best Answers