-
Priority rows
How do I insert a priority row and lock it. thanks Kurt
-
Date Counter for Weekly Ontime Rate
Hi there! I need some help coming up with two formulas that will count how many times in the week we hit our projected due date and how many times we are early. I already have a hidden column that looks at the date and calculates the week of the year. I need the fomulas to read something like: count if 'date completed' is…
-
How to get team involved
What are some ways that you are implementing Smartsheet into your company, team, etc.? I am the creator of the Smartsheet system in my company. I have found that because I have spent so much time in the sheet I have a gap between me and my team that is difficult to close. It all come down to how we get our people into the…
-
Resourcing Allocations
I am trying to find a way to accurately reflect the resource capacity of an individual when assign multiple concurrent tasks in a single day. I appears that if I assign for example 8 one hour tasks (effort = 1h) that the person shows up at 800% capacity for that day rather than being at 100%. How can I make this work? Do I…
-
SmartSheet charting
Is SmartSheet looking into making Excel type chart/graph creation available either within sheets or as an addon?
-
Planned and Earned Value into Project
Wondering if anyone has done any formulas for either Planned Value (PV), Earned Value (EV), into their SS projects? I have all the costing,tasks, opex/capex.%Complete,dates.. in my projects and this would be my next step :)
-
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…
-
Linking Back to a Sheet
We use another platform to create Kanban cards. Is there a unique link on a sheet that is unique that I can copy and paste onto my Kanban card so that the user can easily navigate to the correct sheet?
-
Exporting Gantt Chart
For the Gantt chart, is there way to hide the grid (make borders white) or other way to export the Gantt (Image,pdf..) where it does not show the borders of the cells. Thanks in advance
-
Year Planner Templates?
Does anyone know of a good template for a year-to-view planner? I'd like to also see a list of events too. I've seen it in the templates in MS Excel, but organised for school (mid-year to mid-year). I want to be able to track events coming up (training, exhibitions etc) and who attended. Thanks!
