Document builder and updating the template
I have started using document builder. I have mapped all the fields and the document works well. We had a minor update to the PDF document, which means that I need to remapp the whole PDF. This seems like a lot of work every time you make a change to the template document. Is there a way in which we can "map" the…
Scheduling 30-60 task annual projects with just 200 whole working days per year
I want to develop a template sheet that I can use to easily schedule out 30 to 60 different 30 min subtasks evenly over 200 specific available work days each year. I started out trying to set up a gantt view row with "200d" working day duration then removing sat/sun, and inputting 62 other Non-working days in gantt view…
Formula for Smartsheet PMO Template Project Plan Schedule Health
I have set up a Schedule Health Formula in the Project Plan where it calculates the Schedule Health based on the Health of the Children Rows. For Example, if 1 of the 6 Children Rows(Level 2) is Red then the Parent Row(Level 1) is Yellow and if there are 2 or more Children row(Level 2) are Red then the Parent Row(Level 1)…
How do I subtract "break" time from my Time Tracking Columns?
I'm pretty far along on what I would have thought would be a normal function for a spreadsheet application called "Smart!" Anyway, I need to figure out the last steps in subtracting the break from the total hours worked. It shouldn't be hard as they are one of the following: 0:15; 030; 0:45 & 0:00 or 1:00, whichever that…
automated alerts triggered by number of entries
Hi, I've been asked to help with a form. They'd like to cap the number of entries at 100, and I'm not sure that can be automated. They'd also like to receive alerts after 25, 50, 75, and 100 forms are submitted and new rows are added. I see a way to get an alert after certain dates, but not in the number of entries. Is…
Adjust Column Width in Card View
It would be nice to adjust the width of the columns in Card View (like you do in Google Sheets). Some of my project subtask names are long, so you cannot view what it says (unless you hover over them with your mouse or double-click into the card). If I was able to widen/adjust each column, this would speed up my time…
Hello, Do you have a suggestion of a template to track business performance KPIs? This is for 20 depts across multiple locations so that KPIs will be shared for the same dept across multiple locations. Thanks,
Sharing New Template on Dashboard
We have created several templates that live in folders because they have sheet/report/dashboard tied to them. I would like to share these templates on a dashboard so someone simply clicks on the template and are asked to save the template folder to a new workspace. I haven't figured out a way to do this. Anyone have any…
Capability to Share sheet template in Dashboard
I have created checklist template but currently I don't have a way of sharing this template via Dashboard. (Only thing I find is to move it to shared workspace but this does not work for us right now as a solution. ) It'll be great if we can share the template via Dashboard for others to use.
Add New Template Sheets to Existing Project Workspaces In Bulk Via Control Center
Currently you need to manually add a new "optional" template to each project one by one. This is incredibly time consuming. We need a global update option to add a new template sheet to all existing projects automatically.