Adding Text Value if checkbox is checked

PJ Londergan

I have two columns - One is a checkbox, the other is a text format.

I'd like to write a formula that essentially says, "If checkbox is checked (true) then populate the word "Checked" in the text cell. Else if checkbox is unchecked (false) leave text cell empty".

 

Are there any formulas out there that can do this?

 

Thanks,

-PJ

J. Craig Williams

=IF([Check Box Column Name]23,"Checked","")

 

for row 23.

 

Craig

 

PJ Londergan

Ugh, I SWEAR I tried that and it didn't work. I must have had a bad space in there or something.

Thank you Craig. It's now working.

J. Craig Williams

I always use the [] around column names, even if the column name does not have spaces, Smartsheet removes them, but at least I'm sure.

A common mistake also appears to be removing the spaces when typing

 

[So This]

becomes

[SoThis]

 

Easy to miss.

Glad I could help.

 

Craig