You’re offline. This is a read only version of the page.
Announcements
15
First picture (with the working formula)
Second picture (cell reference becomes REF)
Hello everyone,
I am building a flow that is transferring Microsoft Forms responses into an Excel sheet. The flow is working pretty well. The issue actually happens in the Excel itself. Depending on the answer that is given in the Form, I want the question to go to a certain column or another. To do so, I have used a basic formula (IF). This formula works very well when I am myself writing content (and it's not coming from the flow). However, when the content is coming from the flow itself, a part of the formula (the reference to the cell where the content is put) becomes #REF! Do you know the reasons to that problem, and how I can solve it?
Many thanks!
I added 2 pictures, the first is what the formula is supposed to look like. The second is what it becomes after I run my flow (and therefore after the responses to the form have been added to the Excel sheet.
Share
Report
All responses (
Answers (
