Forum Discussion
MS Forms If function ignoring new data
Hello, I have a MS form setup collating information, I need to then reformat how this data comes in so it can be copied directly into another bit of software. Currently we have sheet 1 as below whic...
Give a try to the following formula-
=MAP(DROP(Form1!J.:.J,1),LAMBDA(x,IF(x="","",x)))Replace Form1 with proper sheet name. If it is Sheet1 then try-
=MAP(DROP(Sheet1!J.:.J,1),LAMBDA(x,IF(x="","",x)))
Hi, thanks for above - I tried above but just got a #CALC! error in the cell
Can you please share a sample sheet link?
Typical Forms response in Excel looks like attached. First 5 columns are always the same, next are answers on form questions.
