+2Hi 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.
Thanks in advance!
Best answer by RnJ
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: ”, ‘’)
+14Can 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: ”, ‘’)
+2Can 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
