Skip to main content

Formula to update status based on checkbox?

  • December 8, 2023
  • 1 reply
  • 14 views

Forum|alt.badge.img+6

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!

1 reply

Forum|alt.badge.img+4
  • Participating Frequently
  • December 11, 2023

Hi @clairehunter 

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

IF(Invoiced,"Invoiced","")