-
Excel Dashboard Templates
Is there any way to upload an Excel dashboard into Smartsheets so that it is converted to a Smartsheets dashboard? My boss is interested in using the Excel templates but annoyed that there aren't any templates available for Smartsheet dashboards. The beauty of the Smartsheet Dashboards is that external executives can…
-
Link to PDF file on Smart Sheet Form
Hello, Is it possible to make a nice hyperlink for a PDF on my smartsheet form? The current link I have is http://www.DOMAINNAMEHERE.com/mbk/RA Submission - English.pdf My first thought was to put an HTML tag in the form, but that didn't work. When I search the community forum, most of the posts talk about hyperlinks on…
-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
-
Identifying all links in a sheet
Another Smartsheet newbie here...I'm sorting through 25 (ish) sheets and there are multiple links between them. Trying to quickly identify all of the Links In and Links out for each sheet to quickly assess how everything ties together. Is there a quick way to pull this info vs. trolling through each sheet?
-
Sharing within a Workspace
I have some folders setup in a workspace. In the column 'Sharing' for the folders, it says 'Workspace'. In the 'Workspace Shared To:' list, it shows three users.. Somehow all users can see the items in the folder, not just the three users in the 'workspace shared to' list. How do I restrict these folders? Thanks!
-
Count Formula
Is there a formula I could use to populate a number into a cell that is a counter of workdays since job has started, and it starts counting once a check box is checked off and stops counting when another check box is checked? this way we can keep an eye on our time frame of a job from start to finish
-
Logic Needed for Turning on the Gray Stoplight
I am trying to add logic in the following string that will turn on the "Gray" stop light ball if the % Complete cell is left blank. =IF([% Complete]18 < 0.5, "Red", IF(AND([% Complete]18 >= 0.5, [% Complete]18 < 1), "Yellow", IF([% Complete]19= 1, "Green", IF([% Complete]19= blank, "Gray"))) I have tried "blank" and "null"…
-
Can I partially mirror a sheet?
Hi, I hope someone can help me with this. What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it…
-
Alerts & Actions
Is there a way to create an alert for a row that hasn't been updated in a specific amount of days?
-
Product Submission Warrant form
Anyone using SS for PSW's? I;m thinking it would be a great way to have suppliers submit their Inspection reports, PPAP reporst etc. Any thoughts?
