Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula to update status based on checkbox?

Topic Labels: Formulas
752 1
cancel
Showing results for 
Search instead for 
Did you mean: 
clairehunter
5 - Automation Enthusiast
5 - Automation Enthusiast

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 1
Harsh2
6 - Interface Innovator
6 - Interface Innovator

Hi @clairehunter 

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

IF(Invoiced,"Invoiced","")