Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Outputting a formula as a checkbox

Topic Labels: Formulas
Solved
Jump to Solution
539 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Gingermatti
5 - Automation Enthusiast
5 - Automation Enthusiast

Hoping someone can help, I saw in Airtable's 'What's New' update in July that if a formula returns "a boolean (true/false), a new formatting option lets you output the result as a checkbox instead of a number". 

This would be really useful for me, but I have tried multiple ways to do this and have not sound it possible. I know Airtable's checkboxes mostly use 1 for checked and 0 for unchecked, so have tried outputting formula as a 1 or 0 for true / false, but no luck (tried "1" / "0", "true" / "false" etc too). Here's the screenshots from the 'What's New' page, if anyone has had any luck with this, help would be really appreciated. 

Check 2.png

Check 1.png

Thanks

 

Matti

 

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Yeah, it’s odd that Airtable doesn’t explain this anywhere. Your output either needs to be TRUE() or FALSE()

— ScottWorld, Expert Airtable Consultant 

See Solution in Thread

3 Replies 3
ScottWorld
18 - Pluto
18 - Pluto

Yeah, it’s odd that Airtable doesn’t explain this anywhere. Your output either needs to be TRUE() or FALSE()

— ScottWorld, Expert Airtable Consultant 

Thank you Scott!

Ignore the AI robot spam response by @Dgmeinsider. It is incorrect info, and the issue was already solved above by me.