Conditional Formatting
Discussion List
-
TimestampingIn Formulas and FunctionsHello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Indenting on smartsheet causing calculation error- help?In Formulas and FunctionsHello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my …
-
IF AND Statement for Color StatusesIn Formulas and FunctionsI am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Cir…
-
Getting top-level heading's rankIn Formulas and FunctionsI'm trying to write a formula that extracts the position of the current hierarchy's top-level heading within the set of all top-level headings. The purpose is to drive some conditional formatting. i.e. If the current row is under the first…Answered - Pending Review 101 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
How do I get conditional formatting rules to update based on "today" as the date.In Formulas and FunctionsHi All! I have conditional formatting set up that is looking for tasks that are due to start today (see first picture below). I chose the "Today" button when I set these up, but they populated today's date and they don't automat…
-
Calculation within IF statementIn Formulas and FunctionsHello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to…
-
Have cells inherit background colorIn Using SmartsheetSo, I have a helper sheet that tracks Budgeted, Committed and Actual spend for an individual project based on the end date from a project sheet. The sheet is laid out where a total of 24 months have their own columns in chronological order…
-
Nested IF statements counting Children color statusIn Formulas and FunctionsHey community, I've found simpler versions of this in the messages, but can't get this one correct. The logic I'd like to express is: If any children under Flag show a Red, then the parent cell (Flag1) is Red If children Yellows are >=…
-
Global Update for Conditional Formating?In Using SmartsheetWe work with the control center, and we have 50 plus sheets of a template sheet. (we have approx 10 templates in the template) We need to change the conditional formatting due to a change in our drop-down lists. As of right now, we wil…
-
Frozen/Unresponsive SheetsIn Using SmartsheetWe're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks