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 🙂
I'm looking for some help with a possible parent/child formula. We have a parent row that lists the project name, then two date columns - start date and end date. The children rows list the tasks that have to be completed for the project. Each of the tasks will have a different start date and end date. The Foreman is…
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
Looking for formula help to accomplish the example below:
