Why is my formula unparseable?

=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A")


The bold is what I want to subtract within the formula.

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You need either a row number or "@row" reference after the first two cell references, and you have one too many closing parenthesis after "Long Term Project". What exactly are you trying to accomplish with your formula?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!