Data Shuttle expressions

Cristian

Hello

How can I get the total count for all entries on a weekly basis using Data Shuttle? Currently I get the total count imported to a sheet. This count is currently 26 entries and it fluctuates weekly. I would like a way that data shuttle using expressions can provide me this total count in one cell.

Thanks for your help.

Danielle Wilson

Hi @Cristian - I think this likely isn't something you'd do with an import expression but could instead be something you created with a formula on the sheet once it was imported. It depends a bit on how you'd like to breakdown the count but if you're looking for the count of how many new rows were added each week, you might do something like do a count that references the "Row Created" date or do a grouping in a report by this date and a "count" in the report.

Cristian

Hi Danielle

Thanks for the feedback. I was able to correct my formula in Data Shuttle and now I get this

Every time data shuttle runs, I get 26s. :)

I could eliminate that expression with a a Count formula.

So for now data shuttle is mostly working. I just recently post this. Maybe you and anyone can help me with this.

https://community.smartsheet.com/discussion/102976/formula-to-auto-fill-cells-in-a-column-going-downward-in-a-row

Again thanks.

Cris

Danielle Wilson

@Cristian If you have Pro Support on your plan, this would be a great topic to book a Pro Desk session for!

Cristian

OK Great. Thanks again.