Worksheets - Display checkmark when boolean field is true

[_James]

I'm setting up an internal door schedule and want to show whether doors are fire rated or not. We mark doors as fire rated via an attached record that has a boolean field creating a little checkbox that people can tick to show it as fire rated or not.

 

I've integrated this column into the worksheet, but it writes "TRUE" and "FALSE" based on the record. 

 

Is there a way that I can make "FALSE" just be blank and not show, and "TRUE" show as a "✓"?

[Matt Panzer]

The following would work if using "User Field 1" in the Data pane for fire rated.  Change "Window.UserFld1" to "YourRecordName.YourFieldName" and it should work.

 

=IF((Window.UserFld1='TRUE'), '✔︎', '')

[_James]

Hi @Matt Panzer

 

Thanks for your reply. My Record is called "Door Data" and the field in question is called "Fire Rated?"

 

I tried inputting that by writing - =IF((DoorData.FireRated?='TRUE'), '✔︎', '') - but this didn't work.

 

Am I doing something wrong? I'm not sure if the question mark affects things or anything like that?

 

[Matt Panzer]

OK.  Try this:    =IF((DoorData.FireRated), '✔︎', '')

and remove the question mark from the field name.

[_James]

Hi Matt,

 

Sorry, still no luck. Would you mind taking a look at the attached file?

 

Door Data.vwx

[Matt Panzer]

Third time's the charm (I think)  🙂

 

Try this:    =IF(('Door Data'.'Fire Rated?'), '✔︎', '')

 

 

It turns out it was't the question mark that was the problem - so go ahead and leave it in the name.  The record and field names have some "special characters" (spaces and a question mark).  In order to get the full names to be recognized, you need to add single quotes as I added.

 

HTH!

 

 

[michaelk]

You can also go to Format Cells… > Number Tab > Boolean and then enter the values you want displayed for True and False 

[Matt Panzer]

Even better!

Thanks @michaelk!

[_James]

Hi @michaelk and @Matt Panzer,

 

Thanks both for the suggestions - problem solved!