nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Formula for when if a checkbox is checked...or not

Marie

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

John Sauber

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?

Marie

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 Mid-Term 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() - [Mid-Term Report Due Date]1 is between zero and 7

Thanks a lot!

John Sauber

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

Marie

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

Much appreciated!

Viktor

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 = Done