-
Timeline View: conditional formatting turns everything gray?
When using the Group feature in Timeline View, I appreciate how each group is given its own color. However, I would like to use conditional formatting to color bars a different color when a condition is met. However, when testing this, every time I use any type of conditional formatting, it turns the entire timeline view…
-
Automation for conflicting events on same dates
Is there conditional formatting function available to trigger a notification in smartsheet when a date is booked for two of the same items? For example; in a scheduling sheet, when the same equipment is booked on the same date?
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
-
Merged: Better conditional formatting options
This discussion has been merged.
-
Bedingte Formatierung
Ich habe folgende bedingte Formatierung definiert und erhalte diese Darstellung Hat jemand eine Idee wo der Fehler liegen könnte? Ich kann mir grad keinen Reim auf einen Teil der Markierungen machen. Lieben Dank für Hinweise Miranda
-
How do add columns in smartsheets dynamically based on a condition ?
I have the date of implementation of the project and I need to dynamically add the columns based on the date. Like for example if I had a 1-2-2024 as my date. It must give ,me 12 months for that date like march 2024 to jan 2025 each column contains 1 month a total of 12 columns and adding to it I have so many projects some…
-
Conditional Formatting based on Status and End Date
Hello, I know this may be have been answered before but I would like some help with the following. I have a sheet with % complete Status (Not Started, In Progress, Blocked, and Complete) Start Date and End Date I would like to create some sort of FLAG or conditional formatting with the following logic. If due date is in 3…
-
Conditional Formatting for Dashboard Metric Widgets
When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard…
-
Send notification 2 weeks after start date
I'm creating a training list template and would like to notify the manager 2 weeks after the start date of any tasks that are marked "not started" or "in progress". the issue is that I can only select a date from a calendar in my conditions but instead I'd like to make it "two weeks from start date".
-
Lock Column Settings
Hello all!!! Quick question I feel like I know the answer to. But is it possible to change a lock column setting so the column locks after a condition is met? For my example a column to only lock after a status is changed to a certain value.