Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula for when if a checkbox is checked...or not
What would be the formula that would return "True" if a checkbox is marcked as checked and "False" if it is not? Thank you!
Comments

This can be done. A simple version for row 1 would look like
=IF(CHECK_COLUMN1 = 1, "True", "False")
Doesn't a check mark do this by its very definition?

Thanks so much John, this is exactly what I was l was looking for. It is part of a much longer logic formula.
Now, while you are here do you happen to know how to express an in between condition? Here is my problem: I want to say that if the MidTerm report due date is over due between 0 and 7 days, then ... What would be the syntax for the part in italic below?
IF(TODAY()  [MidTerm Report Due Date]1 is between zero and 7
Thanks a lot!

Your criteria will not flag things that are very overdue, just so you know. I assume when you say between 0 and 7, that's 1, 2, 3, 4, 5, and 6 days overdue only. You can change the values, of course, or change them from > to >= or from < to <= to include your limits. I think you should be able to take it from here.
Nother tip: we prefer to show true and false is with a checkbox, flag or star column type; it's better than listing "true" or "false" as you'll see below.
https://app.smartsheet.com/b/publish?EQBCT=1262fc277a7d4d86bdc51ab1ac21dc3e

Thanks so much John. I got my whole formula to work.
Much appreciated!

Hi there,
could someone help me with this formula?
=IF(Completed22 <> 1, IF(TODAY()  [Due Date]22 > 0, "Red", IF(TODAY()  [Due Date]22 > 7, "Yellow", IF(Completed22 <> 0, "Blue","Green")))))
Not sure what needs to be changed to get it running.The idea is to indicate:
Green = more than 7 days remaining
Yellow = 7 days remaining
Red = Overdue
Blue = DoneMany thanks in advance!
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives