Discussion List
Notification When Forms NOT Completed
I'm trying to set up a notification that goes to a manager each Monday morning informing him which technicians have not completed a vehicle inspection report the previous week. The link to the form is emailed to each technician Monday morning (eg April 15). They open the form, select their vehicle number from a dropdown…
Multiple rows created within an intake sheet with only 1 form submission
Using Smartsheet for QC sample submission. Some end users may have 10 different samples to submit- having to fill out the form 10 times is not an efficient use of time and there are many redundancies in each entry. Would be great for entry of one form fillable field to be able to have multiple lines of text that are then…
Formula issue
This discussion was created from comments split from: Formula won't recognize cell data.
URL Query String with Dynamic Data Connected to QR Code?
I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
New Employee Onboarding - Forms
Hi - I'm using the Employee Onboarding template set. I want to set up a form within the sheet that managers can fill out with the applicable info: Employee Name Manager's Name Start Date Job Title I want these to populate directly into the sheet from the form The challenge is, because these are row and not column entries,…
Admin Roles but Unlicensed
Will each user that I designate as Admin to a workspace/sheet use a license or can they be unlicensed? Do each of the users who submit data through an intake form need an account?
How to combine cell change notification and Data Shuttle
Hello Community, does anyone has an idea to solve the following problem? I have a data shuttle running every night, pulling information from an excel spreadsheet into a sheet (let's call it sheet 1). Do to the fact that there is no unique identifier in that Excel sheet, Data Shuttle completely replaces all the entries in…
Calendar App with Date Range Issues
Hey everyone. The Smartsheet Community has been so helpful through the process of building a solution to manage our workforce and the hours on our jobs. We are looking to expand our functionality to include a calendar view, but fear all the work we've done will need to be undone in order to create a usable calendar view…
Unable to get the formula correct to merge my data from multiple columns into one column.
How can the name of the approver auto populate into "approved by"?
We have a change order request form for our suppliers to use when requested a change in the design or scope of our projects. I have an automatic workflow to send the request for approval to our construction manager(s). When they approve (or deny) the request, the status changes to approved (or denied) .. but I cannot seem…