How am I able to automatically move newly added rows from a sheet to a dashboard?

Options

The sheet I am currently using feeds to a dashboard that displays weekly updates on 3 project management sites. I was able to add a report to the dashboard that continuously shows new rows of data when they are populated on my sheet, however; I need to be able to harvest the incoming data and separate it into each site's own report- such as a metric report.

Thanks in advance😕

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!