ROI Formulas

nick.wilson

Guess what...it'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å

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!

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

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

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.