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

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?


Best Answer

  • Khasim
    Khasim ✭✭✭✭✭
    Answer ✓

    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.


    Thanks & Regards

    Khasim

    SSPM Consultants

    Email ID: [email protected]

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

Answers

  • Khasim
    Khasim ✭✭✭✭✭
    Answer ✓

    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.


    Thanks & Regards

    Khasim

    SSPM Consultants

    Email ID: [email protected]

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

  • JoshC
    JoshC ✭✭✭

    Thank you, good now!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!