How to set Max 100% in Formula Column

[kedalonzo]

Im using a Formula column to calculate progress however how can i set max value of 100% in case time tracking exceeds maximum no. of hours. See picture below. Also, theres a red exclamation when i divide 0/0. How can i eliminate it since its a milestone and no duration required?

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi Ked,

Try

IF({Duration Hours}>0,MIN(DIVIDE({Work Hours},{Duration Hours}),100),"")

For the %, the easiest way is to change the unit of the column to %. Or you can concatenate the result with %:

IF({Duration Hours}>0,CONCATENATE(MIN(DIVIDE({Work Hours},{Duration Hours}),100),"%"),"")

---

Wished you could create formulas which results could be used in widgets, calendars, automations? You can with a 3rd-party app called the Advanced Formula Booster.

[kedalonzo]

Thanks @GCavin however It computes 2.665% instead 100% . See picture below.

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Not on my machine.

Check your syntax and if you can’t figure it out, publish it here. Also confirm your columns are number columns.