Sights and day prior information

Kylie D'Costa

Hi Team,

Question - we have a sheet which is populated via a web form.

We want to create a Sight that only shows the day prior's row.

So, if today is 10/5/17, we want the sight to show the detail from 9/5/17 only.

Can't figure out a way to do this. screen shot attached for explanation.

Thanks,

Kylie

Shaine Greenwood

Hi Kylie,

It might be best to create a report that shows only that row, then add a report widget to your Sight.

More on creating reports can be found in our Help Center: https://help.smartsheet.com/articles/522214-creating-reports

Kylie D'Costa

Thanks for the suggestion - I've done that and its worked.

I really wish you could better format report widgets  on a dashboard... they don't tend to look all that pretty.

 

Anywho - its worked, so thank you!