ROI Formulas
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)
Answers

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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:andree@workbold.com  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

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.

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
Categories
Check out the Formula Handbook template!