-
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
-
Enhancement Request: Batch Updating in App
Hello - It would be great if a user can update multiple columns (status, dates, etc.) by being able select two or more rows and selecting a "batch update" button to update all of the selected rows at once. Currently, user has to select the column to change, then update a particular field, then repeat if multiple fields…
-
Transferring Cell Data into another Cell's Dropdown List
Hello, My campany is sponsoring a walk for Alzheimer's and I'm trying to create two listed with two Webforms for our site. One will allow companies to register their organizations and Team Names and another for individuals to register themselves. Problem is I'd like the field that takes the Team names on the Team…
-
Suggestions? How to manage/track the Smartsheet workspaces and sheets?
Our SS environment is growing rapidly. Any suggestions or tips when it comes to managing all the sheets. I'm thinking about building a sheet registration Smartsheet that captures who reuested the sheet, when, purpose, department, owner.....etc.... Has anyone done anything like this in the past? Thanks Jim
-
Tracking New Smartsheets - How to request and track the sheets
Has anyone worked on a SS template for users to request/update new Smartsheets? I could use a standard ITSM ticket tracking system, but I'm leaning toward a webform users fill out to request a new Smartsheet. I could use the functionality of SS to communicate updates, gather requirements, and discuss other SS request…
-
Should I have a PM Lite Smartsheet? A One Pager?
This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution in such short amount of time. The beta version of my project template should work for…
-
Sight - Report Widget
Hi All, I have a report with list of names in one of the column, I have linked the names to their respective sheets, the link shows in the report and works fine but when I pull this report in Sight thru Report Widget, link disappears. Edit Interaction in Configure Report Widget can link to only a single sheet , multiple…
-
Is there a way to build a template containing multiple sheets
What I'm trying to do (maybe there is a better way) is to build a project template with contains the project sheet, a requirements sheet, and a budget sheet. When we "use" the template, it then creates all three sheets. Similar to the "Solutions" on the Smartsheet website. Thanks in advance for any help.
-
Formulas
What is the formula to add 90 days to a range of dates that yields MM/DD/YY as the result in corresponding cells?
-
Gantt Chart - Shading after Finish Date to include actual deadline
I'm wondering if I can also use the Gantt chart to identify when we were timely on actions. For example, now it will show a bar correlating with the Start and Finish times. I'm using these as planned start and due dates. If the deliverable was sent after the Finish time, is it possible to have the Gantt chart linked to a…