1

Sorry if this has been asked somewhere else.I am new to SmartSheet and have had a look in community but couldn't find an answer.

I have a Kanban board setup in SmartSheet and have a few reports running that are displayed within a dashboard

Currently I have a report that pulls all items and orders by a creation_date field (oldest to newest) I am trying to limit the report to top 10 items only so that the dashboard is a highlights rather than all data.

 

Any help much appreciated :)

Comments

You would need a helper column on the original sheet. We can use a Checkbox type and call it "Helper".

 

The formula that goes in this column will depend on what you mean by "Top 10 Items". Is it the 10 most recent, the 10 oldest, or is it based off of another criteria?