Range Formulas

You can also configure the furthermost left column or top row of a block by using range formulas. Range formulas allow you create a range of numerical values based on a start, end, and increment. For example, if you input start = 5 and end = 20 and increment = 5, then your outputs will be 5,10,15,20 respectively.

The start, end, and increment fields don’t have to be values that you type. They can also be formulas that link to other blocks (similar to any other cell in a traditional block).

If you are looking for the output to be a date, you can also check the “use date increments” button, which give you date specific increment options such as daily, weekly, monthly, annually, and more.

Last updated