Formula Invalid Operation

09/14/21
Accepted

PTO formula =IF([Yrs of Srv]@row >= 5, "20", "15")

Remaining PTO Days formula [email protected] - SUM(CHILDREN())


When I manually input the PTO days without a formula, the remaining PTO days formula worked. Once I added the PTO formula, I received the error.

Best Answer

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Accepted Answer

    Hi @shornbuckle1072

    I hope you're well and safe!

    Try something like this.

    =IF([Yrs of Srv]@row >= 5, 20, 15)
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    Accepted Answer

    Hi @shornbuckle1072

    I hope you're well and safe!

    Try something like this.

    =IF([Yrs of Srv]@row >= 5, 20, 15)
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • That did it! Thank you so much. I figured is was something simple, I just couldn't figure it out. :)

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @shornbuckle1072

    Excellent!

    You're more than welcome!

    Easy to miss!

    =IF([Yrs of Srv]@row >= 5, "20", "15") The "" surrounding the numbers make Smartsheet interpret it as text.

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.