Form Results to new spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1461075%22%20slang%3D%22en-US%22%3EForm%20Results%20to%20new%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1461075%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20created%20a%20survey%20in%20Microsoft%20Forms%20which%20works%20brilliantly.%26nbsp%3B%20There's%20only%204%20or%205%20questions%20for%20the%20user%20but%20when%20the%20responses%20come%20in%20we%20look%20to%20do%20some%20work%20on%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe've%20added%20new%20columns%20to%20the%20spreadsheet%20for%20our%20own%20internal%20use%20-%20e.g.%20Status%20(e.g.%20New%2C%20In%20Progress%2C%20Closed)%2C%20Response%20date%20(when%20we're%20going%20back%20to%20the%20user)%2C%20and%20a%20couple%20of%20other%20things.%26nbsp%3B%20Again%2C%20that's%20been%20working%20brilliantly%2C%20and%20new%20columns%20have%20popped%20up%20to%20help%20us%20manage%20our%20processes%2C%20which%20has%20been%20invaluable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20we've%20now%20been%20asked%20for%20is%20some%20way%20of%20telling%20when%20the%20statuses%20haven't%20moved%20on%20for%20a%20while.%26nbsp%3B%20We%20could%20have%20a%20column%20for%20status%20date%2C%20but%20what%20I'd%20like%20to%20do%20is%20have%20that%20column%20automatically%20populating%20when%20the%20status%20is%20added%20-%20rather%20than%20relying%20on%20someone%20to%20fill%20this%20in%20(they'll%20forget%20or%20they'll%20lie).%26nbsp%3B%20I%20found%20a%20really%20good%20(and%20simple)%20macro%20but%20the%20problem%20is%20that%20to%20include%20that%20I%20have%20to%20re-save%20the%20results%20spreadsheet%20as%20a%20macro-enabled%20workbook%2C%20and%20then%20I%20don't%20get%20the%20automatic%20updates%20when%20someone%20else%20completes%20the%20survey%20-%20which%20makes%20sense%20because%20it'd%20be%20a%20completely%20new%20spreadsheet.%20Is%20there%20a%20way%20that%20I%20can%20have%20a%20spreadsheet%20with%20the%20macro%2C%20that%20updates%20when%20new%20submissions%20are%20added%3F%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1461075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I've created a survey in Microsoft Forms which works brilliantly.  There's only 4 or 5 questions for the user but when the responses come in we look to do some work on them.

 

We've added new columns to the spreadsheet for our own internal use - e.g. Status (e.g. New, In Progress, Closed), Response date (when we're going back to the user), and a couple of other things.  Again, that's been working brilliantly, and new columns have popped up to help us manage our processes, which has been invaluable.

 

What we've now been asked for is some way of telling when the statuses haven't moved on for a while.  We could have a column for status date, but what I'd like to do is have that column automatically populating when the status is added - rather than relying on someone to fill this in (they'll forget or they'll lie).  I found a really good (and simple) macro but the problem is that to include that I have to re-save the results spreadsheet as a macro-enabled workbook, and then I don't get the automatic updates when someone else completes the survey - which makes sense because it'd be a completely new spreadsheet. Is there a way that I can have a spreadsheet with the macro, that updates when new submissions are added?   

0 Replies