-
Retrieve deleted sheets
Hi, We accidentally deleted the sheets in our accounts, because we want to change the plan. Case number 02911830 Can you please help us how to get back the sheets that were deleted from "deleted items"? Thank you, Divya
-
Project Management/PMO tips
Hi All, I'd be interested to hear how others are setting up smartsheet to support large programmes involving many projects, with multiple organisations, exec sponsors, and project managers. I work in the National health Service (UK) and have a master project list that contains summary information for around 200 projects,…
-
Discussions: Email a Comment
Smartsheet, In the Discussion feature, I find myself needing to write a comment - then click SAVE - then click on the "Email Comment" button - then fill out the person's (or people's) names in the discussion and then click send to get the comment out to the Team. Is there a way - OR can you add a feature - that allows me…
-
Maintaining Formulas When Sorting a Sheet
Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was moved to. My formula is a COUNTIFS and I want it to count what I am asking regardless of where in the sheet the row where…
-
Avg formula % complete based on a specific end date
Hello, I would like to know if it is possible to create a formula that calculate the average % complete for all tasks that are ending at a specific date (important milestone) in my schedule. The schedule I have have a lot of tasks going all the way to 2020 but I want to track only those that must be completed by Nov 2018.…
-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
Report Blank
Hi, I'm trying to create a report based on a sheet I'm an admin on, but it's coming up blank. I build the report based on that sheet, so all the column match. If I select a different sheet it works & shows all the information. I tried deleting it & starting over, still seeing nothing. Not sure what's going on. Help? Thanks!
-
Rescheduling Remaining Work
If you are familiar with MS Project, you are aware of the Reschedule Remaining Work functionality. Does this type of feature exist in Smartsheet? If not, what is used to "push" out work not completed to determine the new end date?
-
Automatic update of adjacent columns
I have a % Complete column and a Status column adjacent to each other. I would like to automatically set the % Complete to 100% if I change the Status column (drop-down) to complete. Is this possible?
-
Webform Email Notifications
We are using smartsheet to Nationally track data. When a webform is submitted there is a requirement to email a certain person within the company notifying them that a report has been issued and action is required. The list of different people who might have to be emailed on the report generated is very long and not all of…