-
Conditional Formatting Based on Modifier
Is there a way to do conditional formatting based on who modified /made changes into the sheet? I have multiple users covering projects and would like to be able to see who was responsible for editing each task. This particular workflow needs to use a horizontal schedule/flow versus a vertical one like most projects.…
-
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
-
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.
-
How to Allow People viewing a shared link to change views
Hello, I want people outside of my organization who are viewing a live link of my sheet to be able to view the sheet in calendar or board view. Is this possible? If not, any recommendations on how a sheet can be manipulated to offer a beeter viewing experience than just the default grid view? For people viewing outside the…