-
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?
-
Dark Mode feature need
How can we get a dark mode feature into the pipeline? It's very common these days for reports and forms to throttle between regular and dark mode. Hope this can be done easily to stay up to date.
-
completed task names auto skipping other tasks?
Hi, I am trying to create a project where depending on a certain task completing or not, the project sheet auto skips other listed tasks. This is very simple, but very hard to communicate via words what I am trying to do. For example, lets say I have a project that lists out how to drive a car. Task 1 is does it have gas,…
