Display Conditionally Formatted Data from an RSS Feed

Hello Community - I successfully created a SmartSheet that populates the Top Row with the most recent RSS feed data. This RSS data adds a new top row to my SmartSheet every hour. I created several formulas in the SmartSheet to display a conditionally formatted value (e.g. red, yellow, or green fill). I have about 10 SmartSheets that all link to different RSS feeds.

I would like to aggregate this data to conditionally display only the most recent value in the Top Row of each SmartSheet. I tried creating a widget on a Dashboard, and the values do not update, nor does the widget display my conditional formatting. I tried a report, which keeps the conditional formatting, but I cannot figure out how to only display the value in the Top Row. Any suggestions from the savvy users of this community?

Best Answers