Conditional Formatting
Discussion List
-
Hyperlink Color on Dark BackgroundIn Using SmartsheetHi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would …
-
Smartsheet function is UNPARSEABLEIn Formulas and FunctionsOn the Sheet Summary I'm trying to write a function that will track Past Due tasks below is the format : =COUNTIF([Is Past Due?]:[Is Past Due?], "Yes") The formula doesn't work as it says "UNPARSEABLE". Below is the Pas…
-
Project Phases of DevelopmentIn Using SmartsheetHello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. F…
-
How to connect Countifs with Jerarquies (Children?) with two conditions ( 100% & Dates )In Formulas and FunctionsHello All, I am running this formula "=COUNTIFS([P%]:[P%], =1, [Finish date]:[Finish date], ISDATE(@cell))", And the result is "7", and that's correct!. But now I'm attempting to run a similar formula just for a specifi…
-
Calculating Schedule Health - RYBGIn Formulas and FunctionsHello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue…
-
How do you link certain information from a form to a sheet or report?In Formulas and FunctionsI am trying to link certain information from a form to another sheet. The form is a questionnaire with a Likert scale from 1-5. If the user select a 1 or 2, they are required to put in a comment. The comment is another question which show…
-
Summary reporting with conditional formattingIn Formulas and FunctionsHello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with c…Answered - Pending Review 231 views 6 comments 0 points Most recent by Stacey P. Formulas and Functions
-
I want my Status column to give me a red circle when it detects a flag in my Critical column.In Formulas and Functions=IF([% Complete]@row = 1, "Blue", IF([% Complete]@row > 0, "Green", "Yellow")) I want to add there to turn red when it detects a flag in my Critical column. Please, help
-
Automatic DeletionIn Using SmartsheetI am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is wanting to use a form to collect the dat…
-
Auto Delete rowsIn Using SmartsheetHI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
