All was good until... Everything was working as designed while setting up PMO template set. Not sure what I did but getting #REF error and would appreciate help in correcting the error . Thank you in advance for your help!
Hello! I am fairly new to SmartSheet and am looking for some advice on how to set up a program management sheet. In short, I have multiple sites which have various tasks I need to track of. I would like to organize by site and task or at least be able to pull a report (or look at a dashboard) that will indicate what is…
Hello Community! Wondering if anyone out there has any best practices for combining a project plan and a resource plan into one sheet. Is this an option? Would that sheet then be able to have the same functionality and link certain cells / info back into Resource Management? Right now, they are two separate sheets, but our…
It would be extremely useful for automation to create a new sheet using a custom template. For example, if a cell changes to a specific value, it automatically creates a sheet or sets of sheets from a custom template depending on the selection.
We are trying to utilize Smartsheet to list out, follow, and forecast our project schedules. The idea is that each Milestone of the Project is the Parent and the steps within the milestone are the children. We are having issues with the parents correctly representing an issue/delay within its children. Right now the…
I would like to see templates related to Mergers and/or Acquisitions. This is part of my companies daily business and we have built all of our templates and flows from scratch. Having templates would give us ideas to improve upon and save other organizations the time of creating them from scratch.
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
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…
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…
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)…