-
Field Service Management in Smartsheet
Has anyone built a Field Service Management solution in Smartsheet? I need to maintain a database of; store locations technicians, their backup tech and their backup of the backup tech dynamic schedule of availability of said technicians I envision some form of a 'lookup' worksheet where appropriate and relevant data from…
-
Conditional Formatting Combined with Dropdowns and Dates
Hello! I have a user tracking the progression of course development and is asking if there is a way to do some formatting on his sheet. The columns shown are set up as dropdowns (there are 8 total columns on this sheet). In the yellow row, in the cells where I've drawn a box, he is going to place due dates. Is it possible…
-
Conditional formatting based on attachments, comments, un/locked status, etc.
Hi Smartsheet, I'd like to see the ability to create conditional formatting based on if a row has attachments, comments, is un/locked status, etc. These features are in the "side margin" on the left hand side. ie. If a row contains an attachment change the font to BOLD. ie. If a row becomes locked highlight a cell a…
-
conditional formatting for Duplicate Values
Excel have Conditional formatting option for highlight the duplicate values. Does this currently exist as an option for Smartsheets or could this be added?
-
Merged: 08075826: how to highlight duplicate values
This discussion has been merged.
-
Merged: Conditional Formatting based on availability of Attachment in a Smartsheet row
This discussion has been merged.
-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up
-
Smartsheet Color Matrix Names and Hex Codes + Programmatic Conditional Formatting
Howdy Smartsheet Community :) During a recent exercise to make Conditional Formatting programmatic, I indexed the color names and hex codes of the 8 x 5 Smartsheet color matrix. Wanted to share the results with everyone here, in case you have a need to extend these colors through non-Smartsheet collateral:…
-
Only Part of my formula is not working and I can't figure out why
I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row = "Control Testing", IF([Actual Cycle Time]@row <= 75, "Green", IF([Actual Cycle Time]@row <= 90, "Yellow", "Red")), IF([Risk…
-
Is there a way to create 2 Reports from one Sheet with different formatting?
I am looking to create 2 Reports from one Sheet that contains employee time off requests. The Sheet contains 13 columns, but for simplicity, the relevant fields are as follows: Employee Name Division Start Date End Date PTO Used (# of hours) Approved? I would like to have one report for the managers to show Name, Division,…