Is there a way to reference another sheet in formscentral responses table? I want to have all the response data tabulated on one sheet and all the calculations on another.
Yes, FormsCentral allows you to construct formulas referencing cells in tables on other sheets. There are two ways to do so:
For example, both of these formulas equally refer to the cell C3 in the table Monthly, on the sheet Expenses:
I hope this helps,
Thank you Marco this is exactly what I was looking for.