ROI Formulas


Guess's me again. I need some help getting these two ROI formulas to work. Any idea why these are coming back as unparsable? Also how should they be?

Formula 1: =IFERROR(IRR([Column2]28:[Column4]28),0)

Formula 2: =IFERROR((SUM(Column3]23:Column3]27)+SUM(Column4]23:Column4]27))/C4,0)


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

    Hi @nick.wilson

    I hope you're well and safe!

    Can you share some screenshots and explain what you want to accomplish with the formulas? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    I hope that helps!

    Be safe, and have a fantastic weekend!


    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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • nick.wilson

    So i am trying to calculate the IRR and I am using this formula: =IFERROR(IRR([Column2]28:[Column4]28),0) which is pulling the from my Net Cash Flow fields. The other formula: =IFERROR((SUM(Column3]23:Column3]27)+SUM(Column4]23:Column4]27))/C4,0) is my actual ROI formula pulling from my year 2 and totals.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    IRR is not a valid function in Smartsheet. What program are you successfully using it in, and what is the intended logic?

    As for the second one... The syntax is technically correct, but you need to make sure you are using column names in your formula that actually exist in the sheet. I am guessing the reference to C4 should actually be [Column3]4.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!