Forum Discussion
tew_ti
Aug 30, 2023Copper Contributor
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
- Detlef_LewinSilver Contributor
- tew_tiCopper ContributorHi Detlef,
"Data table" was exactly what I was looking for; thanks a ton. Hopefully this thread also helps the next person searching with the same keywords I was.