-
Count number of days in date range that fall in current week
Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start Date, End Date, and number of hours required to complete the task. As some tasks will take multiple weeks to complete, I…
-
How to turn off "Track your Team's Workload" pop-up
Every time I open a sheet or report this pop-up message is there. How to turn it off?
-
How to transfer a sheet ownership from a user that is not in my organization?
Hello! I'm trying to take ownership of sheets I am the admin of, it gives me the error, "you cannot take ownership of this item because the current owner is not in your organization". My account was part of the parent company business plan, but now our company got their own plan, so my email is no longer part of the parent…
-
Why would you save a sheet as a template vs saving as a new sheet?
I have a master sheet that I plan to replicate multiple times retaining all configuration I have done ie workflows, attachments, predecessors. It appears that saving as a template and saving as a new sheet would retain all of those features. So what is the benefit of saving as a template vs saving as a new sheet (and vice…
-
Remove Duration from Project Plan Task Unless Certain Criteria Met
Hi there! I am working on building out a project plan template that we will use for onboarding. There are multiple branching paths and decision points that need to be made throughout the process, which determine if certain steps must be taken. I've managed to set up a way to "deactivate" tasks based on those conditions…
-
Dashboard is a blank screen
I am trying to create a dashboard, and when I click "Create", I either get an error message or the dashboard is created but the screen is blank. Any thoughts on why this is occurring?
-
Email ical file to Contact
It would be fabulous if there was a way to send information in a row in an email as an ical file. We coordinate the scheduling of all our external trainings in Smartsheet, but then have to do extra data entry because we then have to create a meeting in Outlook (100% of the time) and in Zoom (40% of the time). Being able to…
-
How to calculate number of days a project is at a certain status?
Hi all, I am looking for a way to calculate the number of days a project is on hold based on a change of status. In my theoretical planner, I set a project start date and input an estimated project duration. This calculates a predicted end date. I have a column where I can define the project status, these are "In…
-
Expand and collapse ALL on the mobile app
I really think it would make things better if I could easily expand and collapse all on the mobile app. It's too much to scroll through on a small screen, and also very time consuming to manually collapse each parent. Especially when it needs 2-5 seconds to save after each change. Please add this feature. I' very fond of…
