-
Indent or minimising rows
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…
-
How to use Forms for populating Sheets
I have bunch of demo units that are used by sales people. I want to use Forms to automatically populate a sheet with a customer name, the desired start date of a demo and the planned end date. Subsequently, I want to use Form to release the use of the demo unit (i.e., make it available for others to use it) as well as…
-
Most Recent Form Entries Metrics
I have a Sheet which is populated by a form, and then calculates prices based on the entry responses. I want to create a metric on my dashboard that displays the pricing information for only the most recent entry, any tips? When I tried linking it to the cells in the top row, it seemed to be a link to that particular cell,…
-
Using a sheet to assign a project number
We use google docs currently for our company to input data about clients, and be assigned a specific project number. We have ~30 employees in the project book pulling these file numbers at any given time, so we like the transparency of seeing who is on what line, so as not to overwrite their data. We then take that project…
-
Form - Column data entry
I can't believe this isn't asked more often...any way of using a Form to populate data into a new column, rather than a new row? Apologies if this has been addressed previously.
-
Too many emails notifications for approvals and update requests
Hello Smartsheet community! I'm asking if there's a way to limit the emails received after each update is submitted through an update request and waiting for approvals? or cancel them and rely solely on the app notification? I have many tasks in each project and I set myself to approve all updates coming from update…
-
Adding items to dropdown lists in web forms
I need to add an option to my form's dropdown list. When I select the field to edit it, the only changes I can make are to the label, help text, display type, and default value. How do I add a value? Thanks in advance!
-
Email based on cell value?
Is there a way to send an email containing the data from a row automatically based on the value in a cell? For example if they choose "Accounting" from a dropdown list or contact list in the "Department" column in row 1, then it would email the data from row 1 to the address on file for the Accounting Department.
-
creating a form but not appearing in the Preview as a full form
I am a new user to smart sheet and I am working on creating a form.The problem that I am having is that all of the data for the forms are in there place but they are not appearing on forms when I do a preview of the form.
