-
New User: Form Creation
A new user here. Can someone confirm? Can a FORM be created from an existing sheet, or does the FORM create a sheet, and then additional columns can be added to that sheet?
-
Link to most recent output of a form
I'm new to Smartsheets and trying to use a form to collect data on one sheet and then link the most recent output of that form to another, master sheet. However, I can only seem to link a specific cell to a specific cell and the form populates a new row each time someone submits a new response. What is the recommended way…
-
Mandatory or Required fields to complete in a smartsheet
I have a need for users when updating or entering data in a cell in a smartsheet that they must complete some mandatory fields. A webform has this function, however on existing rows it would be ideal to have users who are given updates or entering in a new row to have to complete some mandatory fields before final saving…
-
clarification or a how to for forms?
Hello! I am new to Smartsheet, but have caught on. However, while I can create a form, when I send it to someone (or go to the URL myself), any changes made are not showing up in my sheet. How do I make a form specific to a row (i.e. project)? How do I show them the information in the rest of the row (I'm only choosing…
-
Locked rows not picked up by automations
Hi all, I have a spreadsheet with just 4 columns, and i have a set of rules to apply to them. One of those rules is sending Update requests if the date column is over 7days in the past. But, since the spreadsheet will have "countless" rows, i want the rows that had Update requests before, to be locked (easy part) after the…
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Webforms email
I love being able to set the "send me an email" to checked and create a default email address. i use this so that someone (not the sender) gets the summary email with every submittal. But it would be even better if I could make this hidden so that the user does not replace the email with his/her own email. Or have a…
-
Form help - one field per row??
Is there no way for multiple small fields to appear on the same line? I'm wracking my head for what feels like a simple issue... Building an entry form and want a section to look something like (ease of use). Field A [_____________________] Field B Field C [________] [_______] -instead of- Field A [_____________________]…
-
Report Not Updating
Hi everyone, I have a report that is not updating to show a newly added row. The origin sheet has been saved and refreshed. There is no criteria listed on the report that would affect the data to be shown. I'm new to Smartsheet user forms, so I'm not sure if my report is somehow affected by the form or reference sheet.…
-
Forms - Customization
I have created a form from a Smartsheet and when I preview it, it appears to be correct. I have left out columns that I do not need to have a user enter. These are a checkbox column and also three columns at the end which I use for formulas/metrics. Is there a way to hide these in the form?
