Use Excel-Like Capture Mode
Question
In Excel, I can click on the cells
I want to reference in a formula. Is this possible in Adaptive?Answer
Yes, it is possible to use Capture
Mode in Adaptive.Capture Mode allows users to create a formula by clicking on other
cells within a sheet rather than manually entering the formula syntax. To use
Capture Mode:
- Enter = into a blank cell.
- Click on another cell in the sheet to capture it in the formula.Notice that the cell edit box now contains the code of the referenced account, as well as any other pertinent information about the selected cell (i.e. the relative time period or any dimensions). The formula can be further modified by typing in simple operators such as +, -, or *, and then selecting another cell. Each time a new cell reference is added to the formula, separated by operators, a new color is assigned to that part of the formula.
- Hit Enter or click on the green check mark when the formula is complete, and then save the sheet. Alternatively, hit the Escape or Cancel button to cancel the formula.
If a formula is
created this way, and completed, a user cannot return to and modify the formula in
this same fashion. The formula can be subsequently modified by typing changes
directly into the cell edit bar, or by using the Formula Assistant, as described
below.