-
Formula to trigger red flag based on conditional formatting rules?
Is there a formula that will mark a flag red based on conditional formatting of other columns in a row? For example, I've set up multiple conditional formatting rules within a tracker sheet. I'd like to have a checkbox column with a flag that would turn red if some of those conditions were met using conditional formatting…
-
COUNTIF with keywords
Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. "communication"). The cell itself won't be only composed of that word, but will just contain it. My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS("communication", [Job Classification]:[Job…
-
Using checkbox to add value in another cell.
I am not an expert on excel but I am trying to add value (more specific: adding date/time or just time automatically) to another cell just checking a check box cell. Is this possible on smartsheet? Thanks. Al
-
Identify Duplicate Values On Select Dropdown Selections
I want to identify any new rows that are trying to use the same filename as an existing row. We do have reuses, so I do not want those flagged. I was able to set up a checkbox helper column for Duplicates that identifies any filename that is repeated in that column. =IF(COUNTIF([Filename]:[Filename], [Filename]21) > 1, 1,…
-
Conditional Formatting - One rule on multiple columns
Hello, To make our Smartsheets more legible when used for input requests, we use conditional formatting. For example, if we have a table used for percentage-splits with 12 columns and 100 rows we generally pre-populate these inputs where we can with formulas. If the formulas show 0%, it becomes messy fast. To clean it up,…
-
Stumped on an IF formula
I have data in the following fields: Target Sales: Last Week's Sales: I currently have a formula that tells me if Last Week's Sales are less than Target Sales, then return "Yes" or "No" I need to update the formula to tell me if Last Week's Sales are less than Target Sales, are Last Week's Sales below more than 5% of the…
-
How can I make my calendar reflect the color of a data selection?
Hi! I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different…
-
Turn Date Red
I am looking to turn the date red if past due + 7 days. Conditional formatting is not working. Does anyone have the formula to make this work? See screenshot below
-
Hierarchy Drill Through Solutions?
I feed my sheets into Power BI (pre-formatted gantts) and I need to create a way to drill down through levels of a sheet's hierarchy. Ideally, at least 4 levels of the hierarchy, Great Grand Parent, Grand Parent, Parent, Child, if you will. I'd like to mimic the concept that's in MS Project, on the View tab, Data group,…
-
New Taskbar Color for New Project
Hello All, I recently having been building up smartsheet for our agency and I had a questions about the taskbar colors. Right now I have a template that will be used for all new projects. The taskbar defaults to the light blue color. When coworkers use this template, I'd like the default color to be randomized so all…
