-
Capturing multiple statuses, reminders for recurring tasks, form
Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…
-
Allow access to specific items only
Hi all, I am creating a set of sheets. * Main sheet: gathers all the tickets about issues raised from the field (customer). Ticket (row) will be added using a customized form. tickets are coming from several types of users.* Engineers that belongs to the company. * Engineers that are external and belongs to the customers.…
-
Percentage Complete Calculating Differently on 2 sheets
I have a smartsheet that is pushing data to another sheet. Percentages complete are part of the data that is being pushed. On the source smartsheet it shows 45% for a section. On the Target sheet it shows 63% complete for the sames rows. Can anyone explain why I am getting 2 different percentage completes calculated?
-
New form data get inputted after two three rows
Hi, I am facing an issue..the moment I input new form I could see the information submitted two three rows below the last updated rows..can you please advise. How to fix the issue Row 1 and 2 I inputted yesterday When I tried to create a new form today I got updated in row 5 ..ideally it should come in row 3.
-
Submitting a Form
We have a finance form that will submit vendor, invoice, amount etc. in to our sheet. My question is how can I get the information in the form to fall under the appropriate vendor? Right now, the form information goes to the bottom of the sheet and I know that you can set it for the top of the sheet as well. So for…
-
Is it possible to create a web form with appointment time bookings?
Hello, We're looking to run an event where people can meet 1:1 with an onsite consultant but want people to book a time. Does SmartSheet allow the creation of a web form where people can select from a time slot and then it no longer become available for anyone else? Thanks, Julie
-
Can I clean up my FORM email Text?
HELLO ALL, I am a newbie and this is my first submission, thanks for the comments. I created a form which watches the Audio Visual Rooms and reports to the Smartsheet when a problem occurs. It also sends an email to the helpdesk when a certain field (for emails) is checked. The email is generated from the AV SmartSheet and…
-
Cell Text in Form Title/Description
Is it possible to pull values from a sheet into a form? See screen shot for more information. Thank you
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
