Hello All!

I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet.

When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due"


Hi everyone,

I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below)

Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the