Data Shuttle - Need to filter new hires within last 30 days

Options

Hi everyone,

I'm trying to set up a Data Shuttle offload that will export the following information into OneDrive:

  • Employee Name
  • Role
  • Manager
  • Employee Type
  • Hire Date

The problem I'm running into is that I am not seeing any viable way to filter the results within the last 30 days. I setup a report for this as well but discovered that there are no automations that can be configured. Could anyone please provide me a viable way to export this data on a scheduled basis?

Answers

  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭
    Options

    You can't have relative dates in the filter section of Datashuttle, but you can build a helper column on your sheet.

    So on your sheet you could build something like =IF(AND([Hire Date]>=TODAY(-30),[Hire Date]<=TODAY()),1,0) to check a box for all new hires in the last 30 days. Then in the filter portion on your offload, use that field "equals" "true". Example below is just from a CC sheet I used as example, but something like that.


    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

  • jahmeanne
    Options

    Hey Jason,

    This is AWESOME! I'm going to try this right now. Thank you so much, I really appreciate you!