
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 04, 2018 12:50 PM
I am sure this has been covered, but I cannot find a thread that helps me out.
• I have multiple fields that could receive the status of “Approved” from a Single Select list. The fields are “Status 1”, “Status 2”, and “Status 3”.
• I want to create a formula where if any of those fields receive the status of “Approved”, it will check a box in a “Final Status” field.
For the life of me I cannot figure this out.
Any help is GREATLY appreciated!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 04, 2018 01:17 PM
You can’t change a Checkbox field based on other fields. However, you could have a Formula field that outputs a :white_check_mark: emoji if one of the statuses is Approved:
IF({Status 1} = "Appoved", "✅",IF({Status 2} = "Appoved", "✅",IF({Status 3} = "Appoved", "✅")))
Well, you could do it with Zapier: https://support.airtable.com/hc/en-us/articles/206785897-Using-Zapier-to-integrate-Airtable-with-oth...
Anyway, why do you need 3 status fields? Maybe there is a easier way to do what you want.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 04, 2018 01:32 PM
Hmm… Formula looks to be good (no errors), however it is not triggering the emoji. Could it be because my “Approved” status from those fields is in a drop down menu?
I have 3 Status fields because a task could have multiple rounds of changes and/or revisions. It might be approved the first time, or the status might be set as “Revise”. If that were the case, the 2nd status might be the one that gets the approval.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 04, 2018 02:05 PM
I forgot 2 closing parentheses. I recommend you to build the formulas yourself :stuck_out_tongue_winking_eye:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 04, 2018 02:07 PM
I know, I added them. I get no errors with the formula. It’s just not giving me the emoji.
Edit: I got it to work. It was a matter of replacing the emoji. Thank you!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 01, 2019 01:48 AM
We are now in 2019 and pretty close to 2020. Do we have a boolean in Airtable we can use ?
