Sign in to join the conversation:
Is there a way to exclude tasks/rows from the % Complete Calculation?
Yes. You would use a COLLECT function (or SUMIFS or AVERAGEIF depending on your setup) within your formula used to generate the % Complete to specify which rows to INCLUDE. You will need to be able to specify some kind of identifier in the formula for it to compare against unless you wanted to create a long, tedious, rigid, manual formula.
Missing Form Entry Help Needed. Here's my troubleshooting steps so far: Confirmed Link used is correct and it's entries land on the Form Smartsheet Confirmed no sheet filters or hidden columns Confirmed row entry nowhere on sheet, not on bottom Form shows "3 Submissions"
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
