Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Dis-aggregate SS start and end dates in exported Excel

Gordon ✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts



I am trying to see if any of the Excel wizards here can help me with a script or other macro that will disaggregate my SS exported project sheet data that contains start and end date columns (along with the usual duration column) information into individual rows for each day/date that is bounded by the SS start and end dates.


Reason is because I need to compare scheduled task time data (in SS) to actual time reported in another system.  Due to the lack of cross-sheet VLOOKUP capability, I have discovered Power BI and am considering building a system where I combine Power BI with Excel data that I export from SS.  Unfortunately, Power BI doesn't handle date range data very well (i.e., at all!) and can only visualize/analyze date-based data based on a single date column.  Therefore I need to disaggregate each of my project sheet's tasks in SS into multiple rows in excel (one per date), which I can then import into Power BI for further analysis.




This discussion has been closed.