#INCORRECT ARGUMENT SET

2»

Answers

  • nracelis
    nracelis ✭
    edited 10/12/24

    Hi all. Can anyone help troubleshoot this formula? I'm getting an #incorrect argument set error. Thank you in advance!

    =IF([October Hours Under/(-)Over]@row <= 5, "Green", IF([October Hours Under/(-)Over]@row <= 10, "Yellow"), "Red")

    · Share on FacebookShare on Twitter
  • Brian_Richardson
    Brian_Richardson Overachievers Alumni

    The closing parenthesis is too early.

    =IF([October Hours Under/(-)Over]@row <= 5, "Green", IF([October Hours Under/(-)Over]@row <= 10, "Yellow", "Red"))

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!