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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!