-
Conditional Formating
I have a column where multiple values can be selected. When "A" is selected certain other columns are blacked out. I want to have a rule that when "B" is also selected a few of those columns that were previously blacked out become normal again. However, when I try to create the rule for "B" it removes the rest of the…
-
Formula help to convert from total days to business days
I have this formula which gives me the total # of days to complete a construction interval, =IF(NOT(ISBLANK([Construction in Progress Date]@row)), ([Into Pending Lateral Date]@row - [Construction in Progress Date]@row)) How can I convert this to business/work days total?
-
Show % progress on bars in Gannt view
Been searching and can not find any clear answer to this so ill ask (maybe again). Is there a way of presenting the % progress within the bar of a task in Gannt view as it is as default in MS Project for example? It could be enough to have it in 25,50,75,100% increments for me
-
Mysterious strikethrough being added during automation process?
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…
-
How to Automate Email to the Submitter?
I'm trying to set up an automation that will email the submitter once their request has been set to a status called "Approved". I made a Contact list column for the submitter to enter their own email, but when testing this automation, the submitter never got an email. Any help with this would be greatly appreciated!
-
Suggestions for making readable schedules / Conditional formatting last occurrance
Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day contains 5 or more tasks on average. The supervisors who populate the schedule are having trouble when editing rows because…
-
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…
-
Merged: Conditional formatting for rows with an attachment
This discussion has been merged.
-
Merged: Conditional Formatting based on availability of Attachment in a Smartsheet row
This discussion has been merged.