Automation (or formula?) to update status based on...

[clairehunter]

Hello!

I am trying to set up a formula to when a checkbox in the field "Invoiced?" is checked, the "Status" field is then changed to "Invoiced". I am setting this up so that Zapier can (hopefully) check a box if a record is still there and override anything that is no longer in the Excel file. I am trying to create a formula that would do that and can't seem to figure it out. Any help is greatly appreciated! Thanks so much!

[Harsh2]

Hi @clairehunter 

Could you try creating a formula field call "Status" and popping in the below formula

IF(Invoiced,"Invoiced","")