community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Revise the Google Sheets Drop Sheet tool

The behavior of an "Overwrite Sheet (Drop)" configuration is such that it breaks formulas (#REF) that point to the overwritten sheet and named ranges that reference the overwritten sheet.  This is a bummer because the only way I've found to overcome the issue is to write a script that re-applies the named range.  This works, but it greatly raises the barrier to using this tool and in some corporate environments it won't even be possible.

 

What would probably be a good alternative behavior is to delete the contents of the sheet, rather than the rows/columns/cells of the sheet.  I think both probably have valid use cases but my proposed functionality is going to cause fewer issues and be the more popular behavior for most users.  I believe there is a google sheets API call for just this kind of behavior...

5 Comments
Asteroid

Hi,

 

I have been having the same issue for awhile now. I want the data on the sheet to be replaced but without deleting the sheet. One way I did solve this issue is using an indirect formula. Create a new sheet (Datasheet or name it whatever you want) and only place the following code in row 1:

 

=INDIRECT("'Output Alteryx'!A:A")

 

Use the double quotes only when there is no space in the sheet name. If there is a space (as in the example) use single quotes for the name.

Do this for every column (B:B - C:C) etc. and that way you can reference your new sheet which will be an exact copy of your output. Its a small workaround but currently works great for me.

 

 

Meteoroid

Thanks DanielH.  Indirect works!  Kinda Janky but least-janky solution I've found so far.  I still think that formatting should be retained as part of the default functionality of the tool. 

Alteryx
Alteryx
Status changed to: Under Review

Hi All,

 

Thanks for the feedback- please continue to upvote if you're interested in this functionality!

 

Best,

Alex

Meteor

@DanielH - thank you for this solution!  It's the least complex of anything I can try right now to get my stakeholder what they need.  Appreciate it!

Alteryx
Alteryx

@DanielH +1