Conditional Formatting
Discussion List
-
Is there a way to identify and highlight that a particular contact has overlapping dates?In Formulas and FunctionsStaff assignment sheet I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.Answered - Pending Review 20 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Remove a dropdown option , if it is already selectedIn Formulas and FunctionsSurprised, this does not exist yet in smartsheet. I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable. I am…Answered - Pending Review 33 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Newbie Question: Want to Count "Product Name" but only if its date is in the futureIn Formulas and FunctionsHello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting…
-
How do I display a different symbol based on multiple values?In Formulas and FunctionsI've searched the community and tried multiple formulas but I cannot seem to get this scenario to work. I have a '% Not Achieved' summary field, and depending on the % I want Green, Yellow or Red to display. Scenario: 0% = Green 1% - 10% =…
-
How to combine if statements utilizing information in multiple columnsIn Formulas and FunctionsHello, I currently have the following formula to automatically have a color coded dot assigned in a column depending on the due date. =IF(ISBLANK([Due Date]@row), "", IF([Due Date]@row - TODAY() > 5, "", IF([Due Dat…
-
USING FORMS WITH pARENT /CHILD ASSOCIATIONS IN SPREADSHEETIn Formulas and FunctionsGreetings, Below is a screenshot of a spreadsheet that has parent / child associations. I would like to create a form that will allow team members to input the various meetings & Times, they have during the week. 1-can smartsheet au…Answered - Pending Review 50 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Need some suggestions with highlighting info on a trackerIn Using SmartsheetHello everyone, I am looking for some creative support with a sheet that compiles milestones and dates from other trackers to an aggregated sheet with linked cells. The purpose is to share dates/milestones for each project with each column…
-
Mark Duplicate valueIn Formulas and FunctionsHello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
Flagging a Date and Time OverlapIn Formulas and FunctionsHello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
-
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…