% Complete Auto-fill / Default value 0%

Emma S
Emma S
edited 12/09/19 in Formulas and Functions

Hello community :)

Is it not possible for % Complete to default/autofill to 0% when inserting a new row?

When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets auto-filled on the newly inserted row as expected  (ex: At Risk flag, Project, other columns where I'm using a Fixed reference cells with $ sign)... EXCEPT % Complete! It leaves it as blank and therefore another Column for Project Status (which is based on % Complete) shows #NOMATCH.

How can I get % Complete to default to 0% when inserting a new row...?

Thank you!

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!