-
Combo a vlookup/index formula to pull a value from one sheet with cond formatting to another sheet?
Scenario: I have a Project A Plan sheet that has a field for Bill Rate and Role. This bill rate value is pulled in from a Client A Rate sheet via vlookup based on the value in the Role column on the project plan sheet. This formula is currently working fine. The Project A Plan sheet also has a column for employee name…
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…
-
Conditional Formula to highlight all dates = Today
I am still working on my same template. Now there are multiple dates that are using formulas. I would like to be able to use a formula within conditional formatting for this range. When I attempted to do this and selected the word "today" it put in today's date. When tomorrow arrives, that will obviously not be helpful.…
-
Conditional Formatting Issue for column formula
Hello all, I am having an issue trying to use what should be 'basic' conditional formatting for percentages in a column in my sheet, where there are no colors being displayed as intended. Green = 55% or below Yellow = 55% - 109% Red = 110% + The column the cond formatting is referencing is using a formula - I wasn't aware…
-
COUNTIF formula between date range
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the range within which I'm trying to work. For 1976-2000, the formula I have is =COUNTIFS({Game Design Range 2}, >=1976), but…
-
Smartsheets Malfunctioning After January Microsoft Edge Update
Hello All, Is anyone else experiencing issues with smartsheets on their microsoft edge browser? After the lastest update my grid is no longer picking up the color conditional formatting. This color conditional formatting works on the mobile app and on google chrome but does not work on the desktop app or microsoft edge…
-
Dynamic View does not show Conditional Formatting in Blank Cells
Dynamic View seems stumped by blank cells and doesn't properly apply conditional formatting. In the screenshot below, each of the white cells should have a color. As a workaround, we colored the entire column in the source sheet, which seemed to work initially. But then we realized that conditional formatting to change the…
-
Highlight all blank fields without having to set Conditional Formatting for each coloumn?
I have users asking to highlight any and all blank fields in Smartsheet without having to set conditional formatting in each column. Is this possible? Only solution I am aware of is setting conditional formatting to each column, and there are sheets with well over 50 columns.
-
Allowing users to apply "Names" and "Descriptions" to conditional formatting rules.
Hi, my team's resources often utilize a LOT of conditional formatting to help highlight certain things, spot where data is missing, etc. These resources are also shared across many teams and people. Our conditional formatting rules lists are often extremely long with similar-ish formatting for different rules. Being able…
-
Conditional Dropdowns functionality, not available yet?
Hello everyone, I’ve been working extensively with Smartsheet and noticed a significant limitation that has been discussed for years but still hasn’t been addressed: conditional dropdowns. Here’s the scenario I’m struggling with: In Column A, the user selects an option (e.g., "Option 1"). Based on that selection, the…