-
Gantt View Timeline color coded by stages
I am looking to develop a Gantt view that shows multiple colors on a single bar, based on the calendar, and corresponding stage of the project at that time. For example: Project XYZ, single timeline: red during planning stage (Oct 7-14), green during live stage (Oct 15-22), yellow during results review (Oct 23-29), etc I…
-
Automatically updating a super sheet?
I am new to smart sheets and have been tasked with creating a master schedule for our teams. I am working with two different teams on a project and each team has its own schedule. Is there a way that I can set up the team schedules to automatically feed into a super sheet? Ideally, I would like them to identify if an item…
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
Conditional formatting for reoccurring tasks
Hello, I am trying to design a task tracking smartsheet for tasks of varying reoccurrence, i.e., monthly, quarterly and annually. In this sheet, the idea is to use conditional formatting as a means to identify when something is past due (in the past, red), upcoming (in the next 60 days, yellow), completed (green) or in the…
-
Ability to add to drop-down list options in columns with conditional formatting applied.
Idea Functionality: the ability to add options to drop-down lists in columns that already have conditional formatting applied without having to delete and then redo the conditional formatting for the existing options. Idea Use Case: Column titled Status currently has 4 options to choose from and conditional formatting is…
-
Can I conditionally expose a form field based on an earlier entry?
Okay, first attempt at explaining what I want to do.... I have a sheet where I track items (rows) with a multitude of attributes (columns). It's fairly unwieldy so I wanted to provide Editors with a form to submit new items. Current Form: User enters Title and Description (text columns 1 and 2), selects the Category from a…
-
Conditional formatting for error values
Hi, I'm using VLOOKUP for status information from another table. The referenced table sometimes does not have the requested row, so I get back the #NO MATCH error. This does not looks nice, so I was trying to hide from the users and set conditional formatting - if column value equals to #NO MATCH set the font foreground…
-
Linking External Sheets for Conditional Formatting
I am currently working on conditional formatting for a spreadsheet that connects to several spreadsheets. We have a Master Log (spreadsheet) that pulls project dates from multiple Project Schedules (Gantts) so we can keep track of project timelines of milestones. We have roughly 45 fields. 17 fields are linked to Project…
-
Conditional Formatting with percentages
Hello all! I am wondering if there is a way to use the conditional formatting with percentages. For example, I have a report with inconsistent data in each column (some percentages, some just numbers). When I try to condition as greater than 90%, greater than .90, or greater than 90 it includes the full numbers as well…
-
Conditional Formatting on Two Comparable Values
Hi All, I'm very new to Smartsheets and struggling to figure the conditional formatting/formulas out. I have two number columns 'EBT' and 'ABT'. I need to conditionally format them so if ABT is more than EBT, it flags red. If ABT is less than EBT it flags green. Thanks! :)
