% Complete Not reflected the correct % of completion

Options
AAL
AAL ✭✭✭✭

Hi Smartsheet Team,

Here is a snapshot of my Smartsheet. I don't understand even the line 43 is 100% but line 41 is still showing 49% but NOT 100%. Same as lines 50 and 54. Is there anything I am missing here? Thank you for your great help in advance.



Answers

  • Laurie D
    Laurie D ✭✭✭
    Options

    It is hard to know what is happening without seeing the formulas for the cells. Row 38 is the parent for the swag bags rows so it would not be 100% but it should be more than 48%. Are you able to share your formulas?

  • AAL
    AAL ✭✭✭✭
    Options

    Thank you, Lauie for your prompt response. Actually, I don't have any formula in that % complete column. However, what you said reminded me to take a look at my snapshot again, I found out some rows are missing then I remembered I filtered some rows for deferred items but I didn't delete them, so once I unfiltered and put them 100% complete then everything works fine. Thank you so much for your great help and have a good day!