Hello Everyone!
I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet.

I cannot use Smartsheet Reports as a workaround since reports do not support formulas, which are essential for my project. I'm looking for alternative solutions that allow me to consolidate the data while maintaining the ability to use formulas in the reference sheet.

Some advise or ideas would be greatly appreciated!