IF and Statement for Color Statuses.

Jdubb2__534

Jdubb2__534 ✭

08/03/21 in Formulas and Functions

I'm trying to format rows to a yellow color when ‘Date Sent for Review’ and ‘Sent’ status are greater than 10 business days. How do I do this??

0 ·

Answers

James Keuning ✭✭✭✭✭

08/03/21 edited 08/03/21

Create a Checkbox column with the formula:
=AND([Date Sent for Review]@row < TODAY() - 10, Sent@row < TODAY() - 10)
And use conditional formatting (my column is called Test):

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
Multi Select Column to Show as Individual Rows in Calendar App
Hi! I'm trying to build a calendar for speakers assigned to a program. I really want to see a column of individual names and each program they're assigned to in a multi month view. The underlying sheet has the speakers in a multi-select column. The issue is when I have more than one speaker assigned to a program/row,…