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 🙂
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
