-
Mobile app doesn't show dashboard graphs
I can't view any of the graph widgets on the mobile app. Is this a known issue or are my settings wrong?
-
Auto-send PDF Gantt chart of project schedule
We want to be able to auto-send a PDF of projects to our clients on a weekly basis. Can we do this somehow? I know we could share a report for them to view at their own convenience, however, we can't be sure that they will log on to view it regularly which is necessary. to make it easier for them, we would like the option…
-
Formula Assistance
I am attempting to automate my project list by scoring each project based on calculations in another sheet. I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Complexity*weight + cost*weight + impact*weight +resources*weight + value*weight. The values of each category and weight are in…
-
Allocation meeple appearing without any concurrent task
Hi, I got a mysterious meeple over-allocation icon that I have check numerous times did not any have a concurrent task. As I interpret the allocation icon, it means I am doing many task as the same time on which numerous occasion I can clear it by changing the schedule or dividing the task to subtask or phases with…
-
How many cascading multiple sheet dependency can smartsheet can do?
HI, Its me again doing cascading dependency on different sheets. I tried 2 cascading project sheet dependency and it works. I try doing 3 tomorrow but a question lingers: How many cascading multiple sheet dependency can smartsheet can do without any issue? Thanks D Micu
-
At Risk Flag
Good Day All: I am trying to add to the following formula below. If my Due Date (Planned) is within 1 day (i.e. due 04/12/18) and % Complete (Actual) is less than 50%, it should be Flagged. =IF(Duration3 > 0, IF(OR(AND(TODAY() > [Due Date (Planned)]3, [% Complete (Actual)]3 < 1), AND(TODAY() > [Start Date (Planned)]3,…
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Determining an identifier based on parent/children and an additional factor
I have a sheet where I'm tracking IT initiatives, and some are considered Cross-Platform. Some Cross-Platform records have children and others do not. (See screenshot) Based on some reports I need, I have to identify Cross-Platform initiatives, but do not want to include the child initiatives. I created a column called…
-
VLOOKUP vs. Reports
I have created a training checklist template that I am planning to copy as new for each new manager we hire (upwards of 100). I am currently using a Report to pull data from these checklists regarding the managers & their training progress, and will need to roll-up this data in a variety of ways for different program…
-
Day totals for multiple child rows?
Is this a bug? Why can I not get the parent level row to show day totals, for all of it's child rows?