-
Batch Editing
I would love to be able to select multiple tasks on a sheet and change the status if they are all the same. This could affect dropdown columns and date columns.
-
contact
I started a Smartsheet trial yesterday. What I really need is to be able to SPEAK to someone personally about this application! There is no contact number available for "trial users". One found on Google does not work. And any email (3) that I was able to find was either unmonitored or no longer active! How can a…
-
I need to create a high level project on a detailed project that contains a number of indented rows
I have tried to create the high level project sheet using linked cells and the index function however it keeps failing to transfer the information across. I need the sheets linked so that when information is added to the detailed sheet it will update the high level sheet
-
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…