Greetings, I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the we…
Hello! I'm trying to figure out a formula to do the following: 1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level 2.) Display percentage complete o…
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history…
For general project forecasting, I would like to create a project in Resource Manager and assign resources. I would like this to autogenerate a sheet in my Smartsheet Portfolio Folder that holds all s…
I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats w…
Can't figure out how to use 3 columns for a staked bar chart in Smartsheet. Please see attachment. For example, I'd like one column to show all costs for January, with Amy and Joe's costs would be bro…
I am working on a project plan template that has a lot of dependencies enabled for dates, and many of them need to start or end on a specific day of the week. I have searched the community and see a l…
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not cou…
Hi All, Could someone help me figure out a formula for the progress bar column style. My goal is to determine how close (by progress bar visual) are we to the "target end date" of a task. For example,…