=totalfloat() appears to work, but not treated as a number??

JoshC

Thank you SS for finally implementing the totalfloat function. I have implemented as: =TOTALFLOAT([Task Name]@row)

It appears to work. However, here is my issue. I created a new Symbols (stoplight) column and I am trying to setup an IF statement to show green for more than 10 days of float, yellow 1-9, and red for 0 days of float.

=IF([Slack Time]@row > 10, "Green", (IF([Slack Time]@row < 1, "Red", "Yellow")))

The formula doesn't work and it appears that SS doesn't see to recognize the value output as a number. I say this because when i create a new column and type =[Slack Time]@row, it returns a value of 0, even if the Slack column shows a value. if I copy/paste the value from the slack column to the new column, the actual value shows up. Any advice?

Khasim

Hi @JoshC,

You made a mistake in the formula. Please see the updated formula below.

=IF([Slack Time]@row > 10, "Green", IF([Slack Time]@row < 1, "Red", "Yellow"))

I hope this helps you. Please Like and Accept the answers if they are useful to you. It will also benefit other users.

Need more assistance? I'd be happy to help you.

Khasim

Hi @JoshC,

You made a mistake in the formula. Please see the updated formula below.

=IF([Slack Time]@row > 10, "Green", IF([Slack Time]@row < 1, "Red", "Yellow"))

I hope this helps you. Please Like and Accept the answers if they are useful to you. It will also benefit other users.

Need more assistance? I'd be happy to help you.

JoshC

Thank you, good now!