-
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…
-
Report Builder - What section
Hi, I'm trying to number actions on my list as 1.1, 1.2 etc, all relating to a section 1 in my smartsheet. I also have a handful of actions that I need to number as 1.6a and 1.6b etc. When creating the Report Builder however, the 'What' section doesn't seem to handle the letter, only the number, therefore any rows that…
-
Formula Help
I am trying to match a cell on our contract status report and pull that cell information into our recruitment sheet. On the contract sheet name is in the first column and contract status in the sixth column. I want the contract status to populate into a cell on the recruitment sheet by name. I was thinking that VLOOKUP…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Formula to count back 30 working days
How do I create a formula to subtract 30 business days from a certain start date? I was trying to use =WORKDAY ([start date]13, -30) and it's not working. Note: the 13 is the row with the date I'm counting back from. Thanks for your help!
