Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Check a checkbox in a formula

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

Hi!

I have two checkbox fields, column A and column B.

In the column C, a formula, I would to write: Column A checked and Column B checked. I would like the result as a checked checkbox.

Do you know if it is possible to see the result as a checked checkbox?

Thanks in advance!

1 Solution

Accepted Solutions

Welcome to the community, @Maesihox! :grinning_face_with_big_eyes: Unfortunately formulas can only output text, numbers, and dates. However, emojis fall under the text category, and there’s a green checkbox emoji. Your formula might look something like this:

IF(AND({Column A}, {Column B}), "✅")

That would output the emoji if the checkboxes in both {Column A} and {Column B} are checked; otherwise it would leave the field blank.

Will that work?

See Solution in Thread

2 Replies 2

Welcome to the community, @Maesihox! :grinning_face_with_big_eyes: Unfortunately formulas can only output text, numbers, and dates. However, emojis fall under the text category, and there’s a green checkbox emoji. Your formula might look something like this:

IF(AND({Column A}, {Column B}), "✅")

That would output the emoji if the checkboxes in both {Column A} and {Column B} are checked; otherwise it would leave the field blank.

Will that work?

Thank you very much! :smiling_face_with_halo:

I know this solution but I don’t think at first. It works :thumbs_up: