Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Displaying the result of a formula as a check box

Topic Labels: Formulas
Solved
Jump to Solution
302 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,

I’m looking to display the result of a formula as a read-only check box. The result of the formula is always a 0 or 1.

Here is the formula:
IF(AND(OR({Meal Plan Shopping List Recipe}, {Non Meal Plan Shopping List}), NOT({In Pantry})), 1, 0)

Adding a screenshot for reference. I’d love it if the 1/0 column could show a checkbox if 1 and nothing if 0, like the other columns.
image

Thanks in advance!

1 Solution

Accepted Solutions
RnJ
8 - Airtable Astronomer
8 - Airtable Astronomer

Can you just use an emoji? Like this.
IF(AND(OR({Meal Plan Shopping List Recipe}, {Non Meal Plan Shopping List}), NOT({In Pantry})), “ :heavy_check_mark: ”, ‘’)

See Solution in Thread

2 Replies 2
RnJ
8 - Airtable Astronomer
8 - Airtable Astronomer

Can you just use an emoji? Like this.
IF(AND(OR({Meal Plan Shopping List Recipe}, {Non Meal Plan Shopping List}), NOT({In Pantry})), “ :heavy_check_mark: ”, ‘’)

Yes, that works! I didn’t even think of that, it’s exactly what I was looking for. Thanks!