I think the ability to change the background color in smartsheet would be very beneficial in helping avoid eye strain. Most of us are looking at white screens all day and our eyes get very tired and strained. Even with special blue blocker glasses I still notice the eye fatigue. Please consider adding this feature in a…
I have created a sheet template from an existing sheet. The existing sheet, prior to saving as a template, had many rows of data The template copies all the data from the original sheet. I only want the sheet layout and formulas. Is there a quick way to remove cell data on the template sheet. I guess better approach is to…
There's an excel Iterative plan template posted on the Smartsheet site. Can a similar template be provided in Smartsheet?
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…
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 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)…
