Sheet summary - count of Status from multiple source sheets

M_L ✭✭✭✭✭


I have 7 source sheets that I would like to use for a sheet summary report. Only one of the sheets is returning values to the report.

All the sheets have the same 'Status' column, with the same values in the dropdown.

Question is: why is only one sheet returning values?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!