-
How to automate Harvey Balls based on % Complete Summary Field
Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated. Thanks, Robert
-
Dropdown only options
If I have set up a dropdown, can I disable users from typing in text. I ONLY want people selecting from the dropdown.
-
Formula Separator
I'm attempting to create Red Yellow Green balls based on 2 formulas in one row. I have one formula for early, late, on time, and another for whether the phase has been completed. Basically I want to show green if the row is early or on time and/or if it is completed/cancelled, but red if it is late and/or stalled or not…
-
Thank you!
I just want to say that I truly appreciate the Smartsheet team. Every question I read that has to do with improving Smartsheet, I read "We will add your vote". I have never seen a company that was so responsive to their customers requests and suggestions! I just wanted to take a minute and say thank you! Laurie Bearden
-
WARNING: Links in email points to earlier versions of attached files
Hi all, This may be old hat but I just discovered this scenario exists in Smartsheet. 1) You attach a file to a row and send the row with the file linked in the email to User A. 2) User A replies and makes you aware of an error in the file. 3) You correct the error and then upload a new version of the file. Smartsheet now…
-
Card View: Multi layer views
Hi, Are we able to do multi layer views? Ie. Departments as primary level and then Status (WIP, Complete, etc) by second level? Thanks.
-
Web Forms in Tabular format.
Dear, There is any way to create webform using the actual spreadsheet? I would like to have similar functionality to the webform that smartsheet sheet but in tabular format. For example, everytime a person would click on the link to access the form, they will have blank new spredsheet to fill out just with the column…
-
IF() Statement troubles
In Excel I can use the following statement with no issue: =IF(A89="","",(WORKDAY(A89,-3,Holidays!$A$2:$A$9))) I tried the following in Smartsheet and receive the error: #BLOCKED. =IF([Launch Date]36 = "", "", (WORKDAY([To Production by 3 pm (Site merch deadline)]36, -1, $[Holidays 2016]$1:$[Holidays 2017]$13))) Any…
-
Visio Import Problem
Importing Visio documents and returning a blank sheet?
-
Reporting based on % of work
I need to have an initial graph of the amount of planned work schedulled for each week of the project. The "X" axis will have each week and the "Y" axis the % of work to have done. I am sharing a graph as an example. The blue line will be the planned baseline project. The red line the real work on a weekly basis. Any ideas…
