Conditional Formatting
Discussion List
-
Change Milestone Diamond ColorIn Using SmartsheetHi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀
-
Trying to identify cells in ALL CAPS vs Title CapsIn Formulas and FunctionsI have a sheet where I've pulled a list of titles that exist on a series of URLs in either all caps or title case. I need to be able to identify or sort by the lines that are in all caps so that they can be corrected - is this possible?
-
Smartsheet Forms - Displaying View Only FieldsIn Using SmartsheetWe have a SS Form that we are using to collect Project Go-Live Confidence for that month. The Form provides the PM with the Project Mgr Name, Project Name and Current Go-Live Date along with conditional questions. We want some of those f…
-
Conditional formatting with formulasIn Using SmartsheetIs it possible to conditionally format a cell where based on the answer to one cell the formatted cell changes its formula?
-
Equation to populate new numberIn Formulas and FunctionsHello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last co…
-
SUMIF multi-condition syntaxIn Formulas and Functionsa Coworker and I have been banging our heads on this one for a couple weeks now for a project under development. We're trying to SUM hours {TotalTime} within a date range that meets a label criteria (@cell, Month16). It actually works unti…Answered - Pending Review 33 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not StartedIn Formulas and FunctionsHi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF([email protected] = "Completed", "Green"…
-
Workaround for VotingIn Using SmartsheetHello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have…
-
Filter to show only dates from this week???In Formulas and FunctionsI'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
-
How to alert regarding a duplicate value within a row?In Formulas and FunctionsHi I would like to add some sort of alert or conditional formatting, but I'm not sure how to accomplish this. For the columns impacted they are all dropdown single select columns. I want some sort of alert, could be as simple as highlighti…Answered - Pending Review 39 views 7 comments 0 points Most recent by Genevieve P. Formulas and Functions