-
More than one Baseline + Comments
Dear all, To enhance Smartsheet as a comprehensive PM Application, my company and I find that a crucial feature, baseline management, currently needs to be added. While the ability to set baselines is valuable, the limitation of only being able to set one baseline is a constraint. We propose the implementation of a feature…
-
Create a what if scenario using a late start date
I am working with a project timeline with dependencies. I have set up 2 additional date columns for late start and late finish where the late finish date is a formula for late start @row + duration. How can I set this up to calculate all the dependent late dates for start and finish? For example, I have several activities…
-
Campaign Calendar
Hi, I am trying to set up a campaign calendar in smartsheet. But when Calendar tries to pull information from the spreadsheet, this is how it looks(attached). It cuts in between the rows. I created a ticket, but smartsheet closed it without resolving it. Can anyone help?
-
How to set up an automation that is based on an if statement?
Hello! I am trying to set up an automation that changes a cell to "Complete - Pass" when four different conditions are meet. The way I am doing this is by adding and additional column that does a pretty complex if statement, and from that it either returns "Pass" or "Fail". =IF([QA Filter FAIL]@row = "Fail", "Fail",…
-
Best Approach for Forecasting Resource Availability in Smartsheet?
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…
-
Resource usage reporting at project level - warnings of over allocatoin
Can a view of a project plan be developed to show the allocation of a resource within the project itself. It should report when the project itself has over allocated a resource due to multiple activities using the same resource over the same time period. A view Similar to that in MS Project would be ideal, where you can…
-
Why automation copies the row 3 times instead of once?
Hi everyone! On Smartsheet, I have a source file for which I created an automation. Through this automation, the 7 rows of the source file (whose values are updated multiple times a day) are copied to another destination file. According to the automation, the copy should only occur once a day at 4:00 p.m., and the goal is…
-
Embedding from the Calendar App
Is there a way to embed a calendar you created from the calendar app without placing it as a widget in a dashboard?
-
Merged: Sheet Banners
This discussion has been merged.