Forum Discussion

tew_ti's avatar
tew_ti
Copper Contributor
Aug 30, 2023
Solved

Question about how to populate a table using multi-cell formula

Hello,

I have a question about how I can populate a table using a formula/procedure that involves multiple intermediate cells.

As an example, I have an input column that defines the inputs into my function, and would like to populate the table with the corresponding outputs. With a formula that can be put into one cell, this is easy enough. However, in this case, my formula involves multiple intermediate cells. For this example, it is a simple process to get the output, but in the real-world cases I work with the calculation may involve hundreds of cells.

I can manually enter an input (under "Calculation i/o") & then manually write the output to the table, but I was wondering if there was a way to automate this, like when the formula is just one cell.

 

Example:

 

I know this has probably been answered before, but I can't seem to find the proper keywords to search for it.

 

Thanks,

Travis

 

 

Resources