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!

Using check boxes and flags in formulas

pea.ccu49236

In my project sheet I have checked boxes and flag. I would like to include them in my formulas.

Example:

If the box is unchecked by X date then the X date will appear in a reminder column.

Find more posts tagged with

Government

Project Management

Cell linking

Comments

Paul Newcome

Try the below formula replacing "Date" and "Space" with your column names...

=IF(AND(Date1 < TODAY(), Space1 = 0), Date1)

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt