Forum Discussion
Solved
MS Form Response Spreadsheet Formulas
I have set up a MS form and am trying to format the response spreadsheet to pull through the response data into a new sheet for editing. I have set up a formula to do this but every time a new respon...
- You should probably leave the table alone and use Data, Get Data to pull the results into a separate Excel file. Add your logic to that query.
BTW: ISBLANK(TRUE) always returns FALSE, so you might as well replace that bit with FALSE in your formula.
You should probably leave the table alone and use Data, Get Data to pull the results into a separate Excel file. Add your logic to that query.
BTW: ISBLANK(TRUE) always returns FALSE, so you might as well replace that bit with FALSE in your formula.
BTW: ISBLANK(TRUE) always returns FALSE, so you might as well replace that bit with FALSE in your formula.
- Thanks for your suggestion. Would this pull through any subsequent data that was collected via the form?
N_Wall2000 Yes, refreshing the query would pull in the latest responses.
