Best Of

Is it possible to create a form that autopopulates information from an existing sheet? As a step one in my process, I have individuals filling out a form. For example, information such as name, email, location, etc. For step two, I'd like to pull answers from those questions to autopopulate the next form that needs to be filled out.

@Loann McGee - Here is SS's intro article on Dynamic View - Smartsheet Dynamic View | Smartsheet

We use DV's a lot to break through the noise of a Sheet. It allows to show only the columns and rows that we want someone internally or externally to see WITHOUT having to sharing the source sheet. Then when clicking on a row, a pop out on the right will appear that will allow more and/or the same data to be shown (and edit if you decide), comments and attachments. Similar to a sheet but visually different. However since the user shared to the DV isn't shared to the source sheet, you cannot properly @mention something in the comments which is a huge fault in my opinion for collaboration.

We build our DV's off a Report instead of directly from a Sheet. It allows for greater filter options and/or a second layer of filtering options. We then usually embed them in a WorkApps and add other assets for our Partners but we've also added direct links to Dashboards or inside Sheets as well. We then only need to share the WorkApps (besides any DVs that are embedded in the WorkApps). It gives an easier user experience, navigation and partner branded professionalism for our Partners who don't normally have Smartsheet. This is just once example for us.

More advanced users can use Field Logic in the Details panel which is a nice feature. Meaning you can selective pick which cells are visible only, visible and editable, or just hidden based off a criteria. Example, a ticket status system, if it's in Stage 1, all cells are editable, but if it's in Stage 2, only certain cells for approval are editable, etc. So depending on the status, the cell options can change. There's other great features as well not mentioned.

I hope that helps.

I think many people have found this an issue. I would advise you search the Product Ideas and if you find this Vote it Up or raise a new one as hyperlinks in Forms and in Automated emails would be SOOOO helpful.