Conditional Formatting
Discussion List
-
Conditional FormattingIn Formulas and FunctionsI've tried out the conditional formatting and am unable to show different colored backgrounds for different future date conditions. As an example: I want to show the date cell to show green if it is a future date with a Green Background …
-
Case sensitive COUNTIFIn Using SmartsheetI'm trying to mark duplicates in a particular column per the discussion here: https://community.smartsheet.com/discussion/comment/319478#Comment_319478 My issue is, the column I'm checking has a mix of uppercase and lowercase letters that …
-
Using a dropdown to pull duplicatesIn Formulas and FunctionsHello, I have created a "helper" column to help me find duplicate entries within a row. So all of my columns are going to be drop down entries so as to avoid spelling or typo issues. If a person appears in "Faculty on PTO&qu…Answered - Pending Review 4 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Hierarchy issuesIn Formulas and FunctionsHi everyone, I have been pursuing the forum but I can't seem to find the answer. For some background, my company had a team that set up our Workspace and sheets. One of my coworkers was also the admin but recently left for another job. I h…Answered - Pending Review 20 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Conditional Sheet PopulationIn Using SmartsheetIs it possible to use conditional formatting or formulas to suppress unnecessary tasks? And, if so, could Smartsheet adjust dependencies for removed tasks? For instance, we have a sheet to track product implementations; however, some pro…
-
CountIf for check boxesIn Formulas and FunctionsGood afternoon, Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box? Thanks
-
Formula for Quantifying Importance based on Priority Level and Due DateIn Formulas and FunctionsHello, I am looking to create a formula to help prioritizing tasks based on importance and due date. I assigned a value for the priority level as: =SUM(IF([email protected] = "High", 6, (IF([email protected] = "Medium", 4, (IF(P…
-
Gantt Chart Parent Row BarsIn Using SmartsheetHas there been an update to allow color edit to the gantt chart parent row bars? Thanks - Julie
-
How do I make a Smartsheet that keeps track of initialsIn Using SmartsheetI'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many …
-
Automation Suddenly Not WorkingIn Using SmartsheetI have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??Answered - Pending Review 434 views 11 comments 0 points Most recent by David Horowitz Using Smartsheet