Referencing another Sheet

is there way reference sheet in formscentral responses table?  want have response data tabulated on 1 sheet , calculations on another.

hello jkujak,

 

yes, formscentral allows construct formulas referencing cells in tables on other sheets.  there 2 ways so:

1. using numbers-style references:  myothersheet::sometable::a1
2. using excel-style references:  myothersheet!sometable!a1

 

for example, both of these formulas equally refer cell c3 in table monthly, on sheet expenses:

 

= expenses::monthly::c3

and

= expenses!montly!c3

 

i hope helps,

marco

More discussions in Archived Spaces

adobe