Automate data source range within dashboard widgets on linear/line charts

Is there a way to automate this process? I have a report as well on my dashboard that goes into detailed statuses, but my leaders respond to trending data (especially if it goes negative).

FORMULA DATA GATHERING SHEET: automated


CAPTURE TRENDING DATASHEET: automated


UPDATING DASHBOARD WIDGET: MANUAL


Best Answer

Answers