-
Autopopulating date/ cannot edit
Hi Smartsheet peeps, I am having date trouble in my project sheets. Below is the process I do: 1. Use dependencies to autopopulate the actual start and actual end at beginning of a project 2. Copy and paste those dates into the grey planned start and planned end columns 3. Edit the actual start and actual end date columns…
-
Template: Team Task List by Priority
Hi Everyone, I'm new to Smartsheet. In the Template titled Team Task List by Priority, there are headers. High Priority, Medium Priority, Low Priority and Completed. My question is: how do the tasks in lines below the priorities get assigned to which priority? Do they get auto-populated to each priority based on something?…
-
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…
