-
Master Roll-Up for multiple project sheets
I am reviewing the Construction and Facilities Management template set provided by Smartsheet. I only have a Team account for now. The template comes with 2 sheets for Projects. In the Master Roll-Up sheet, you can see the formulas used to pull the info from the 2 Project sheets. Question: Do I have to manually update the…
-
How to set up and automate a template for this report chart in the dashboard?
Hi guys, do you know how to set up the following report chart in my dashboard? I have seen this kind of report chart in one of the Smartsheet webinars. My requirements to this report chart would be : Every time I set up a new project plan, every person in my "Assigned to" column should be automatically involved in this…
-
Template set with URL Links not working
I have a project plan with 3 supporting worksheets. I want to launch the supporting worksheet FORM within my project plan. So, I copied the supporting sheets FORM URL into the attachment cell on the appropriate row for each corresponding support sheet. So far, so good. Then, I did a "Save As" using the option to have all…
-
Dashboard Form Widget - Product Enhancement
I am sure that I am not the only one that has copied a dashboard with needing to go back and edit the "web content" widget which contains a Smartsheet form. It seems like this is one of the few things that does not update when you copy a folder containing your sheet, form, report, and dashboard. Thus, if you have updated…
-
Annual Calendar Template by Day multi activities
Hi, the default set up for the Annual Calendar template seems to only anticipate one activity per day. How can I input multiple Activities per date without adding a new row and duplicating the day of the week and date?
-
Facility Bookings
Hi all. We manage many government/public venues and facilities (sports arena, stadium, parks etc) for which we facilitate bookings. At present, bookings are logged using outlook only viewed by one person. We'd like to begin using smartsheets for bookings so clients (the public) can view available (or unavailable) dates,…
-
Print table into template
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
-
I need help so that I can calculate a percentage of completion
Guys, I need some help. I am struggling with calculating the percentage of completion of the whole sheet based on how many tasks are Complete in the Status column, or maybe better said to calculate the completion percentage based on the Parents Status in the Status column. Thank you and I am waiting for your advice.
-
Schedule Health formula not working,
Hi, Can anyone help me with a formula i have three scenario .1 & 2. IF start date and end date % complete activity exceed the daily % completion , Status should be In progress and color the schedule health to Green 3 % complete is less than the expected work to be completed within the time frame it should be Red and status…
-
link hourly rates to project schedule
I would like to link my artist's hourly rates to tasks in a project schedule to get an estimated hard cost. How do I do this?