Formulas!!!! Will be the death of me LOL - % Completion - Having a hard time

Jen6122

I have been taking courses and training and growing my knowledge with Smartsheet - however - Whenever trying to determine the % Complete of a project based on dates - I have issues. Nothing works. I finally found one formula that it accepts, but, of course, it doesn't work correctly - all the percentages =100, which isn't correct. (it obviously may be an error on my part, which I am sure it is) Please help. Any ideas? I need a formula to calculate the percentage of a project status.

Jen6122

I went about the entire sheet with another approach. Success. I appreciate your help and concern and will no doubt be using this tool again in the future!!!! I love Smartsheet - great community!

Melissa Yamada

Hello @Jen6122

% Complete by Status. Does the Status you're referring to is a column with a dropdown of Not Started, In Progress, and Complete? If so, do you have specific criteria in mind like if it is In Progress then % Complete is 80%?

Can you share more info on how you'd want your % Complete to show based on status? Then I can help you with a formula.

Jen6122

I have a Planned start / Planned end and then Actual Start and Actual End. Health Column / Days remaining and Project status (In progress, Not Started and Complete)

Melissa Yamada

Hello @Jen6122

I found this thread that might be helpful to your requirement:

https://community.smartsheet.com/discussion/100108/what-formula-to-use-in-status-column-based-on-complete-column

Paul Newcome

How exactly would the percentage be calculated? Is it based on today's date in reference to the planned start and finish? What is the logic you want to use?

Jen6122

I went about the entire sheet with another approach. Success. I appreciate your help and concern and will no doubt be using this tool again in the future!!!! I love Smartsheet - great community!