Set formulas in action

You can set the result of a formula or a formula itself in a cell using the 'Set value into cell' action on the 'Cells' tab and 'In sheet Set value into cell' action on the 'Sheets' tab.

Set the result of a formula in an action

For example, you can set the result of a formula by setting " = formula " as follows.
../../../_images/img_01.en253.png

Set formula in cell with action

For example, you can set the formula itself by setting " ="formula" " as shown below.
../../../_images/img_02.en239.png

See also

How to dynamically add controls (buttons) with actions, refer Dynamically Add Buttons

Related keywords

function