Display Value as %


My company uses a formula for the Target % Complete which basically looks at the start and end dates of a task and gives the percentage of work that should have been completed to date. The formula is as follows;

=IF(Start1 <= TODAY(), IF(Finish1 <= TODAY(), 1, NETWORKDAYS(Start1, TODAY()) / INT(Duration1)), 0)

My issue is that using this formula in a new sheet gives the value as a decimal point not a percentage like in other sheets. Could someone help me understand where I am going wrong with this formula, please?


  • Ramzi K
    Ramzi K ✭✭✭✭✭
    edited 10/02/20

    Daniel, try changing the format for the cell (or column) to % format using the toolbar.

    Hope that helps.


    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Daniel Barber

    So simple and I completely overlooked it! Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!