We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the c…
I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that projec…
We have a large project management sheet with several levels of hierarchy and many summary rows and child rows. We want our staff to be able to use calendar view to easily visualize how their tasks la…
Hi. We are creating a Smartsheet dashboard for our incoming projects. Each project manager will need to make comments to their respective projects. Is is possible, if we add the project report to our …
Working on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correct…
Hi all, Is it an option to Filter out items based on 1 cell in a sheet? We have a project plan and there is a cell that designates the entire project complete that is at the top. Is there a way to exc…
This was first raised in 2016 as a missing critical feature. It seems its still not available... has there been any progress in implementing this? Looking to migrate to a collaborative tool but withou…
We have several projects with us, and would like to display them all together clearly in a timeline. Unfortunately I can not find a template or anything else for this, can someone help me? for example…
Why has product development ignored the need of real project managers to be able to calculate durations based on task effort and resource allocation percentages? This is one of the most basic needs of…
We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to…