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.
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
I have inly one user in my trial account. When I am trying to upgrade to PRO plan it is defaulting for 2 users and not allowing me to upgrade the plan for only one user. Please help.
How can I delete old sheets I no longer use from my account?
