Format Formula as Checkbox

#1

I have a condition that Inputs Boolean and outputs Boolean, and i wish to make it appear (format it) as a checkbox and not as a string “true” or “false”

IF(Field1 = TRUE(), TRUE(), FALSE())

Thanks

2 Likes
#2

Hi @DanielAssayag - I don’t think you can format it as a functioning checkbox, but you could implement a formula with the “true” value as an emoji:

Formula I’ve used is:

IF({T/F} = TRUE(), “:white_check_mark:”, “:x:”)

More details here:

JB

1 Like
#3

Even though this solves the issue, I also second the request for checkmarks as a formula format. Why, because emojis look different o every device, aren’t center aligned, and are harder to use as filters.