-
Intake sheets add on process flow task management aligning with project plan
I am setting up a sort of hybrid project with a large cable manufacturer, the project started and stopped during COVID and they had no task management. I am to use SmartSheet for the project plan, which I have mostly in place other than sites not visited yet. At the end of the day, I am standing up an OT network at several…
-
Team Vacation Planner - automation to notify if too many people are taking the same day off
Hi there! Is there any way smartsheet can set up an automation that if there are too many people taking the same day off it'll send an alert to me? I have a start date and end date column I also have another helper sheet with each day (excluding holiday, Saturday and Sunday) in each row and different departments as column.…
-
Changing more than one sheet
Hi, I was wondering if there was a way to alter sheets based on a single template without having to go into each one individually? If I had a template that I used for different task lists and I wanted to add a column, automation, or even a choice in a dropdown, is there a way for me to do that simultaneously throughout all…
-
How do you fix a missing reference?
Using the PMO template, I keep running into errors where my references are broke or incorrect. For example, on my Portfolio Metrics sheet, my references should be listed like below. Instead I only have Project ID. My formula is the same. How do I get back the missing references of Portfolio Summary Data and Portfolio…
-
How to prevent the auto adding blank rows ?
Hi all, Smartsheet keep adding new blank rows to the bottom of the sheet even though if they are deleted manually . Is there away to prevent the auto inserting new blank rows ?
-
Index/Match/Max Function Issues
@Paul Newcome @Andrée Starå I am having issues matching a cell value from my project status column. My goal is to reference my most recently updated (max modified cell) data entry and return that value in the selected cell. My current formula for reference: =INDEX([Project (Schedule) Status]3: [Project (Schedule)…
-
Dashboard Template
I have multiple projects that have their respective project schedule sheets and I created a dashboard of one project. I was wondering if there was a way to make a template of that dashboard so that I could make the same dashboard for all of my individual projects.
-
Formula to calculate difference between projected and actual dates
I have a project schedule where I have projected and actual dates for most of the deliverables, and I need to track the faster project path. Is there a formula that can automatically select the earlier date between the projected submit date and actual submit date? Is there a formula that will automatically select the…
-
How to project a completion date with predecessors and durations
I am building out Engineering project plans. I'd like to be able to pre-plan the work out by using predecessors and approximate durations. However, if the first line item in the plan does not yet have an end date the predecessors/duration will not calculate to give a projected end date for the project. I had a call with…
-
Vacation & Time-Off Management
Has anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
