Conditional Formatting
Discussion List
-
Conditional formattingIn Formulas and FunctionsHi All, i wonder if there is a formula to help me out to change the task color bar match with my Assigned to column
-
CHANGE ON SITE AFTER IS CONFIRMEDIn Formulas and FunctionsI have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment …Answered - Pending Review 44 views 10 comments 0 points Most recent by Christina.R Formulas and Functions
-
Complex nested IF, AND with traffic light symbolsIn Formulas and FunctionsHi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity compl…
-
Formatting on Smartsheet workflow notificationIn Formulas and FunctionsHow to make formatting using HTML tag or using CSS for workflow notification (for Alerts and Approval Request). Its very useful for and impressive for user attraction to highlight the few area for example: A workflow has 6 approval step (3…
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?In Formulas and FunctionsI have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in th…
-
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 …
-
Formula to shift numbers in a columnIn Formulas and FunctionsI have a column called "Priority" that has my tasks (rows) ranked by importance, with 1 being the top priority and 10 being the lowest priority. When I check off a task I want to delete 1 from the most important task and have tha…Answered - Pending Review 25 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Smartsheet causes CPU usage spikesIn Using SmartsheetI'm using Smartsheet in Google Chrome and notice that when it's left open for a period of time, Chrome is using a lot of CPU resource, to the point that the mouse won't move smoothly across the screen and typing is delayed appearing on scr…
-
I need to use an IF / THEN formula to compare a cell from one column to a cell in another columnIn Formulas and FunctionsI could really use some help! Thank you in advance! My STATUS column has the following colored options available per cell: Red, Yellow, Green and Blue. I am looking to use the following IF / THEN statements: 1. In STATUS, if the DELIVERY…
-
Process flow that also includes daily task checklistsIn Using SmartsheetI am new to SmartSheet. I've developed a comprehensive process flow for our recruiting process. It has the tasks to be done, start/completion dates, who they are assigned to, and other steps. But there is one thing I can't figure out. Wi…