% of theoric progress

Adil-Dkaki
edited 12/09/19 in Smartsheet Basics

Hi all,

I try to add colomn for % of theoric progress and use it with the real progress on formul to define different status (Done, Not Started,Task in Overdue, Work in Progress)

Formules sur smartsheet.JPG

Comments

  • Hi Adil-Dkaki,

    Smartsheet treats percentages as values between 0 and 1. For example, 0% should be expressed as 0 in a formula, 75% as 0.75, and 100% as 1.

    Try converting your percentages into decimal values in the formula (make sure to remove the % sign as well). Here's an example of the formatting using a small chunk of your formula:

    =IF(TODAY()<[Columne]5, 0)