Pulling data from one smart sheet to another to create chart on results

Hi all

i need help on how to pull data together.

I need this data to be grouped on a chart to either show qtys or percentage which I cannot do with reports.

I have a column that shows my individual products that we are working on and this is abased on a formula in each cell to formulate the data . This column is called Model Name


=[Unit name]@row + " " + [Unit Size]@row + " " + "X " + Bed@row

I need a way of reporting on each individual variance found and if a match add to count

Unit Name is constant and pulled from a drop down

Unit Size is unknown and can vary ?

Bed@Row is constant and is from a drop down.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!