Forum Discussion
Solved
Formula in Forms for Excel updates automatically
Hi, I have a OneDrive Business Plan, which allows me to create Forms For Excel in my OneDrive. I have created a form named "Training Request Form" using the Forms for Excel at a location i...
Please check in attached file.
I'm not sure why do you need to replicate Form to categorize data. Perhaps you may simply add another column to Form for that and use it. Additional column won't affect answers collected.
Hi Sergei - Thank you for the response.
So I am trying this, and just wanted to confirm ROW() will consist of ROW(2) right? Any more changes I will need to make this to work?
Is there a simpler way to do this?
So I am trying this, and just wanted to confirm ROW() will consist of ROW(2) right? Any more changes I will need to make this to work?
Is there a simpler way to do this?
Please check in attached file.
I'm not sure why do you need to replicate Form to categorize data. Perhaps you may simply add another column to Form for that and use it. Additional column won't affect answers collected.
- Thanks Sergei, I will check this. The reason I want to replicate is that my form has branching questions, which means when viewing the form it shows with gaps and looks inconsistent therefore, I'd like it to be displayed in a proper tabular format based on the information filled in the form