-
Dropdown Lists by Individual Cell rather than by Column
Hi all, I was just wondering if there is something I am missing here. Is there any way to create dropdown options by cell rather than for the whole column? I am trying to create a Creative Brief and there are a lot of fields that I want to be able to control the options people can choose from, rather than allow free text.…
-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
CAPA - Industry Standards (benchmarking)
I am in the Medical Device industry. I am looking for some bench marking information around what a well rounded CAPA system Metric should look like. For example: What is the typical percentage of CAPA types in your CAPA System. For example: Random numbers here: 78% Corrective 14% Preventive 7% Internal Audit Corrections 0%…
-
Sheet Security - Prevent Sheet Export and Printing
Is there a way to prevent sheet from being able to be exported and / or printed? We have multiple users accessing data with sensitive information on a sheet, however we wouldn't want those users printing or exporting that data, but still keep the access to edit the data on the sheet. Any thoughts?
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
How can I create new entries/rows and make sure the link's rule applies automatically to them all?
Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother 's sheet. I added a new last row but the Links to the secondary sheet are missing.…
-
Is there a way to show the report and give edit access to add comments and add attachments?
I have designed a workflow for our team and used the Request system workflow as a start. I created a report and attached the link in the email when someone submits the form. I have this report linked with the underlined sheet where my entire team works. V have information that shouldn't be shared with anyone outside the…
-
Using Smart Sheet and Web Form to manage testing
Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing same test case? I'm currently using a reporting template but there are numerous…
-
Webinar recording: Dashboards introduction and best practices
Missed the webinar? Review the recording in the Learning Center. Join us for a two-part webinar series focused on Smartsheet dashboards. Introduction to Dashboards Learn how to build a visual Smartsheet dashboard to provide a robust, real-time view into data from your sheets and reports. Dashboard design best practices…
-
Conditional Logic in Smartforms (AKA Cascading Dropdowns)
We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsheet) is the need for Conditional logic or Cascading Dropdowns when completing forms in…