-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
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…