Set up formulas in your Spreadsheet documents to make calculations in seconds. Set names for the named ranges that contain the results of your calculations. They will be automatically available for use when setting up bots.
Let’s see how formulas work when we need to calculate the total expenses for a specific period of time:
1. Select the cell where you’d like the result of the calculations to be placed. Enter the = symbol, then start entering the function you need (SUM in the example). You can then select the function you need from the list.
Then, select cells containing expenses by dragging them to the bottom.
The formula will be automatically generated for the selected cell.
Hit Enter on your keyboard to calculate the result.
Create a named range for the cell and define its field type so that you can use it when setting up bots.