-
Join columns from 1 match
Good evening, I'm looking for some assistance :) I've been trying to find the formula that alows me to join 3 columns value of the same line of the match. This is between 2 smartsheets. I made a quick draw of it. I would appreciate any help :)
-
NEW: Submit offline forms on mobile
Hi Community, Have you ever tried to submit a form on the Smartsheet mobile app, only to realize you had no internet connection? Whether submitting expenses on a plane or safety inspections on an oil rig, you need the ability to capture information anywhere! Now, the Smartsheet mobile app allows users to mark a form…
-
Offline Forms
Can anyone tell me if offline forms is available yet???? Cheers!
-
How to display "closest matching" rows based on an "input" row?
Hello all! I've been building out what is essentially a database to track information related to customer orders of a specific product. The product is essentially custom tailored firmware - specifically, automotive engine tuning files. Most of the information is provided by a customer through a form, some is manually input…
-
Prevent deletion of help text in forms when editing column properties
When editing the column properties from inside a form, if changing either the column label or the question type, any help text that the user has entered get deleted. While you can always edit the header in the sheet itself, it does not make much sense for longer forms that may have taken multiple drafts (questions…
-
How to count the number of times a value appears based on multiple criteria in another column?
Hello, I am trying to create a formula that counts the number of times an email appears based on a number of selections made from a drop-down menu. The process is for counting the number of trainings completed per quarter per employee. The trainings are submitted through a form and only one training title can be submitted…
-
Project Management with Multiple Subprojects
Hello! I'm looking for recommendations on the best (aka easiest) way to create and manage subprojects within a project. Our current systems are set up to have 1 project number, 2XXXXX, with several subproject numbers, 3XXXXXX, depending on how many phases and shipments of the job there are. The subproject numbers are…
-
Alerts but send populated Fields only
The form I use to gather data is made up of circa 150 columns, and different columns are populated each time a form is filled out, depending on options selected in the form (logic). When I set up an alert, I just want it to send populated fields so they don't have to scroll through a big list of empty fields to see…
-
Allow Reports to display Attachments as a thumbnail
We use Forms to capture defective works in the field which then attaches an image to each row in our Defective Works Sheet. We would like to be able to have a column assigned as an Attachment field in order to have the Report display text fields with the accompanying image in the body of the report, rather than the little…
-
Form Query String - Changing Hyperlink
I need to create a form that will have a unique, clickable URL code. I can successfully autofill a section of the form to contain this hyperlink but it is not clickable since it is an editable field (see example below). Any ideas?