-
Document Builder: Conditional Formatting & Symbols
It would be great if document builder was able to: either apply conditional formatting within the builder or carry through conditional formatting from the source fields/sheets able to pull through field properties such as symbols as the graphical representation rather than the backend text e.g. I want to include project…
-
Help with a formula
I am trying to get THe project column to auto populate with the "children" from the source sheet when the "sign Type" is selected.
-
Merged: Apply conditional formatting to a range of Columns or Rows
This discussion has been merged.
-
Request for Update Automation Logical Conditions
Hello, It would be incredibly useful to have the option to build a logical condition within the automation request for updates. Currently, our form is sent to our sales reps weekly for updates, but user errors often occur as they miss certain boxes. I am unable to implement the logic that if one box is checked, the other…
-
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…