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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!