Let's say that a user has a tracking study where and they want to display the column sample size for the most recent wave in a text box. If the data was static (i.e., no more waves would be added), we could easily do this using a dynamic text box that referenced a single value in a table. However, since the data updates with newer waves of data, the input table wouldn't be static, as the "last" column would change with each update. So, instead, users are forced to use R code to rig up a custom calculation that shows the column label and column sample size for the ncol of the table.

I suggest that we update the dynamic text box options to allow users to reference columns left/right, similar to what we can do for visualizations. It would also be helpful to add the option for the columns to be dynamically referenced to support changing column headers as well.