I have a SmartSheet form I want people to complete, but want to use a SharePoint document library for all the submitted forms. What's the best approach to getting this done?
Hi Wes,
You can add the form URL directly to SharePoint like you would other links. I found a SharePoint help article on adding links and applying styles to them to fit the theme of your site: https://support.office.com/en-us/article/add-accessible-content-and-links-to-a-sharepoint-online-site-dc34fac7-32d7-4dcf-b694-2cc6115ac8b9
Information on obtaining the Smartsheet form link is available in our help center: https://help.smartsheet.com/articles/522221-using-web-forms
You can also consider embedding the form in SharePoint, more info on that in this SharePoint help article: https://support.office.com/en-us/article/use-the-embed-web-part-721f3b2f-437f-45ef-ac4e-df29dba74de8
In Smartsheet, you can obtain the embed code, which gives you the iFrame code needed. To do this:
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…