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.
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…
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
Help with formula to count BLANKS in Assignee field across multiple children rows
Hi all, I'd like to count only the rows below where the Assignee field is BLANK. The problem is my formula is counting the parent rows (ECS Inbound, ECS Outbound, Flat File Inbound). I know that =COUNTIF(Assignee28:Assignee60, "") will count blanks but how do I get the formula to only count the rows in that range if they…