-
How do I get a sum for each location (Room 600-605) excluding expired materials?
In this first image the "Complete Count QTY" column sums the materials excluding expired materials. This works perfectly. In this image you can see my attempt at getting a sum for Room 605 in the "Location Specific QTY" column excluding expired materials. This is where I have a problem. Ideally this would read 4 in the…
-
Is there a way to create multiple rows in a sheet based on a numerical answer on a form submission?
I'm trying to track new hires via work orders. I'm wondering if there is a way to create the number of rows indicated in a form submission on my tracking sheet? For example, should I indicate that I am trying to hire 8 individuals for a certain role, is there a way to automatically add 8 rows to my sheet that copy all the…
-
Alert Triggers?
Good afternoon, everyone! I had a quick question about automation for a Smartsheet form. I set up a workflow to be triggered when a date is reached (today- 3/29) and repeating every week on Tuesday starting on 03/29 and ending on 04/13. The alert is set to go to specific people (including myself) at a specific time (9 am…
-
Dashboard Form Link Icon
This happened once automatically without me doing anything special, but I can't seem to reproduce it. On a project dashboard, when I created a link to a Smartsheet form, Smartsheet recognized it as a form link and gave me a nice icon. Was this feature introduced and then quickly removed, or something? Anybody know how to…
-
Form & Automation Ownership Transfer
Hello, it is possible to transfer Ownership of a Form or Automation from one user to another without having to deactivate the form and create a new form? Thanks
-
Tracking form back to workflow
I am receiving an update request form that is coming from an old sheet, but I can't find the workflow that is creating it. Is there a way to track the form back to the sheet/workflow that is creating it? Or is there a way to list all my active workflows somewhere? I think I own the sheet that is running this, but not sure.
-
Auto Populate G702/703 from Schedule Sheet
Our accounting dept is wanting to auto populate g702/703 invoice form, for monthly billings, from project schedule sheet. Has anyone been able to complete this task or something similar within smart sheets? If so do you have any guidance you can provide? I am a bit stumped and feel notifications would work best but I am…
-
Enhancement request -dynamic dropdowns in forms
Haven't seen this topic brought up in a minute, so thought I would bring it back up. Dynamic dropdowns in forms would be huge for us.
-
Can I modify the error message displayed if a required field is not completed?
I have a form that includes a set of questions that are multi-select checkboxes: If the user does not select a checkbox and tries to submit the form, the error message is not grammatically correct. Can I modify the error message shown to the user?
-
Sheet populating at row 51
I recently created a sheet and form for patient safety surveys. When the form is completed, data is populated starting on row 51. What did I do wrong and how can I get it to populate starting at row 1?
