-
Creating Expiration dates based on products
I want to create a formula that will auto-generate expiration dates for individual products for an entire column. The sheet has a created date and column containing a dropdown list of products. The products have different expiration dates. Ideally I would like to format the expiration date column to have the product…
-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of…
-
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
-
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…