Dashboard widget flexibility


Is there top show a subset of tasks from a project plan on a dashboard and ONLY have the end date filled in once marked a 100%? I made a report of the subset of tasks but I am unsure if it is possible to not include the date until it is 100%. Maybe a report is not the solution, but if there is a way to do this report or not please let me know!


  • JamesB
    JamesB ✭✭✭✭✭✭


    The End Date column is needed for your project. I would suggest you had a helper date column to your sheet and use a formula to populate it.

    =If([% Complete]@row<>1," ",[End Date]@row)

    Then on your report you can use this column and not the end date column.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!