Display Conditionally Formatted Data from an RSS Feed

Lauren Doud

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?

Genevieve P.

Hi @Lauren Doud

The way I would do this is to add two helper columns (hidden) to each sheet. The first is a Created Date System column, which will automatically date stamp rows as they are added to your sheets.

The second will be a formula column, identifying which row is the most recent or the MAX row in the sheet.

=IF(Created@row = MAX(Created:Created), 1, 0)

This helper formula will give you a unique flag for your "top" row, or most recent row, that you can then use in your Report! Here's the Helper Column used as the Report filter criteria:

Let me know if this makes sense or if I can explain anything further.

Cheers,

Genevieve

Lauren Doud

@Genevieve P. Thank you so very much. It is working like a charm now.

Best,

Lauren

Genevieve P.

Hi @Lauren Doud

The way I would do this is to add two helper columns (hidden) to each sheet. The first is a Created Date System column, which will automatically date stamp rows as they are added to your sheets.

The second will be a formula column, identifying which row is the most recent or the MAX row in the sheet.

=IF(Created@row = MAX(Created:Created), 1, 0)

This helper formula will give you a unique flag for your "top" row, or most recent row, that you can then use in your Report! Here's the Helper Column used as the Report filter criteria:

Let me know if this makes sense or if I can explain anything further.

Cheers,

Genevieve

Lauren Doud

@Genevieve P. Thank you so very much. It is working like a charm now.

Best,

Lauren

Genevieve P.

Wonderful! I'm glad to hear it, thanks for following up.

icaldwellctv

Hello, I'm interested in learning more about the RSS import functionality. Wondering if this was done with a template? Or custom coded? Ian