Sign in to join the conversation:
Hello,
How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red?
Is that possible?
Yes, if you choose the formatting option in the toolbar you will be able to color the row or the cell based on the date column you choose being in the past. See screenshots below.
More on Conditional Formatting.
Is the "in the past" criteria for conditional formatting still available? It doesn't appear in my Smartsheet as an option.
Hi @LGraf
Can you double check that the column you've selected is formatted as a Date type of column?
Wow, you are totally right. How embarrassing! Thanks very much.
Not to worry! I've done that before, too 🙂
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
