Conditional Formatting
Discussion List
-
Form entry/Copy row automation/Row locationIn Formulas and FunctionsHello all! I am really hoping this is something easy I am just overlooking. The sheet above has a form. When the form is completed the row of information does not populate in the first available row, but a random row typically 25+. The she…
-
Reference Entire Sheet AND Filter Rows Where Column Value ="Search Value"In Formulas and FunctionsI am simply trying to do the following: - Refer to another sheet (ALL ROWS and COLUMNS) with the following conditions: - Where in Column [STATUS] is = "Done" The RESULT should be: - This new sheet shows all rows and columns fr…Answered - Pending Review 89 views 10 comments 0 points Most recent by Jeff Reisman Formulas and Functions
-
Conditionally changing cellsIn Formulas and FunctionsHi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through…Answered - Pending Review 435 views 11 comments 0 points Most recent by A Rose Formulas and Functions
-
sorting by fill colorIn Using SmartsheetHello, Is it possible to sort rows by fill color? I currently have a conditional formatting rule that assigns a color to a row and would like to be able to have those rows grouped together. Thanks.
-
Enhancement Request: Allow changes to Column Type when Conditional Formatting is setIn Using SmartsheetIf a column is associated with any Conditional Formatting, the column type can not be changed. This is true even if the Conditional Formatting Rule is disabled. This is true even when changing Column Type from 'like' types, for example T…
-
When can we expect an expanded color palette for Sheets?In Using SmartsheetCurrently in Sheets for background fill and fonts, there is only the option of 5 shades of 8 basic colors as shown below. When can we expect this to be expanded to a full hex palette like for charts in Dashboards?Answered - Pending Review 58 views 3 comments 0 points Most recent by Adrian @Chess Using Smartsheet
-
How can I link two forms from two different sheets to put the answers on one singular sheet?In Using SmartsheetI want to be able to have two sheets with two different forms, but then I want the two forms to also have one sheet with the answers from both forms so that the answers are combined. Is that possible? If so, could you help?
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)In Formulas and FunctionsHello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been rece…
-
Setting Formula using RYGIn Formulas and FunctionsHi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=S…Answered - Pending Review 36 views 5 comments 0 points Most recent by Heather Duff Formulas and Functions