VLOOKUP and Conditional Formatting

I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its due date no longer works on the VLOOKUP cells

Is there something I'm doing wrong? Or is this a limitation of the software? Has anyone else had this problem?

Find more posts tagged with

Calendar View

Formulas

Conditional Formatting

Project Management

Card View

Cell linking

Comments

Mike Wilday

I saw another post this morning about disabling the rules and re-enabling the rules to fix some visibility issues. Give it a shot and see if that fixes it. If that fails, try recreating the rule and see if that adjusts anything.

J. Craig Williams

I have seen and reported this problem during my testing of X-Sheet references.

Deleting and recreating rules (or anything else for that matter), is not a solution, unless someone from Smartsheet will be doing that for us.

Untrue story: I went to my car mechanic and explained that when I was driving down the highway between 68-70 mph, the car would start to veer to the right. She suggested I turn off the radio, open the rear windows, and if that failed, to pull into the next rest area to see if that fixed the problem. I have a new mechanic now.

Craig

Chris McKay

Careful Craig. There's just been an update to your dashboard, so you can no longer tell whether you're doing 68-70 mph and the button for turning off the radio is now under the hood.

J. Craig Williams

I was wondering why the windshield wipers came on when I tried to turn off the radio. Thanks for the heads up.

Craig

Mike Wilday

True, True. Not a good solution. Things should work when you're trying to work. But who doesn't love it when you get your car fixed by your mechanic and several other problems occur as a result.

joconnor

Yeah, it looks like it started working again after disabling and enabling again. The first step in IT!

Thanks!

Mike Wilday

Well... not an ideal solution, but at least it's working again!

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…