Unable to make the following formula a column forumula

The error message is that the syntax is not right.

=IFERROR(NETWORKDAY([Date of Visit]1, Created1) - 1, "Need Data")

I've always gotten such great support here. I appreciate any help.

Best,

Craig

Tags:

Best Answer

  • Isis Taylor
    Isis Taylor ✭✭✭✭✭✭
    Answer ✓

    @Craig Lemberger Have you tried adding "@row"?

    =IFERROR(NETWORKDAY([Date of Visit]@row, Created@row) - 1, "Need Data")

    Isis Taylor

    🎓️ Core App and Project Management Certified 🏅

    🌟Peer Connect, Mobilizer, and Early Adopter Program

    Business Analyst Senior

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!