Regarding question 1, I haven't worked with Sharepoint, but this links looks like it might contain what you need: Dan's SharePoint Blog: How to Link Your SharePoint List to Excel! Regarding question two, it looks like you are trying to populate column BL with a counter that is one less than the current row number (starts counting from 1 on row 2). Oct 22, 2020 · Map the fields of the Events element with the columns of your SharePoint calendar. Most of the fields are mapped automatically but you are able to modify everything the way you want. For detailed information on mapping, please check Step 4 of this article: ShortPoint Connect: Basic Tutorial. Click Insert when ready. I'm looking to auto-populate another column based on the response from one of the questions in the form. In the form I have a multiple choice with the names of 19.01.2017 · I have a form in SharePoint Online that has four fields - User Name, Job Title, Department and Office. The User Name field is a...