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 am trying to create a formula that will separate text. I can't use the Left or Right and the length of names is different. Example: I need to return the first name only in a different column. Format is LastName, First Name Full Name First Name Smith, Joe Joe Jones, Ralph Thompson, Leah Robbins, Sam Robinson, Sally…
For my Customer ID column, I'd like to count how many cells have errors so I'm trying this: =COUNTIF([Customer ID]:[Customer ID], not(iserror(@row ))) The Customer ID column is a lookup from elsewhere, and typically the error that could show up is #NO MATCH. I've tried a few variations of this formula but can't get it to…
I seem to have an issue only if I'm using the default Start/Finish columns in a project plan template with a formula. I need to have a Start date X days after Go Live but it won't accept that a formula is a formula when I use the template columns but it will work if I create my own data column. Here is the formula: =([Go…
