You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formula calculation for a column in a form for specific number of rows

Received Response
edited Aug 21, 2021 6:06PM in Financial Consolidation and Close 8 comments



We are building a form and it has have many number of rows and columns. But our requirement is to create a formula in a column to find difference between 2 other column cell values.

For eg: we have around 300 rows and columns A, B and C.  C is a formula column here and need to populate the difference between values in rows cells 100 to 200 from column A and column B.

The formula [B]-[C] in column C returns difference value from column A and column B cells for each row in the form, which we do not want it.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!