downloadable formulas

**emergencymonkey** · 11-11-2013, 01:29 PM

I have a website that gathers information on a webform. This webform has fields that have numerical values associated with them. When I download the submissions to an excel file it puts each submission in its own row. As such, if I were to create a "total" cell through the webform, it would be something like "=f2*g2" which works. However, and there's always a however, that would only work for the very first entry and the subsequent submissions would all be "=f2*g2". I'm looking for a way for the cell to be changed based on the row number WITHOUT touching excel.

I hope that makes sense. I am trying to get my webform to plug in the right formula when it is exported to excel and account for the row that each submission is in.

I've tried things like: ="f"$row() but that just gives me a cell that says eg.. "f4"

Any help would be great!!
Thanks in advance.

**ragulduy** · 11-12-2013, 05:27 AM

=INDIRECT("f$" & row())

**emergencymonkey** · 11-12-2013, 06:47 AM

Haha, that was too easy

I couldn't find that for the life of me! Thanks a ton! Worked like a charm and I figured out how to make calculations along with it

Thanks again

**arlu1201** · 11-13-2013, 01:56 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.