HI Community I need help creating a custom auto number formula using set prefex and a reference column. The DRN "number" or Identifier must populate as follows: ABCDE-DRN24-020T. The prefix 'ABCDE-DRN…
It would be awesome if, when setting up automations, there were a check box for "Send Custom Email?" that opened up a dynamic field when checked. If checked, a new menu opens that allows you to edit t…
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case n…
I've set up an automation to go to the contacts listed in contact column. One contact is a cell phone number with SMS gateway code so that it can go as a text. It works great, other than it repeats th…
I have gotten the automation to work moving rows from one sheet to another. For some reason though, the copied rows go into the new sheet 30 rows below the next available row? Any ideas?
I am currently working on a Solution for a Pilot program that three of our Pharmacy Sites are participating in. This Solution will contain 4 forms and 3 Scheduling Calendars, One of the "asks" was to …
Hi, I have a sheet wherby i have statuses, start and end dates, and also an Active field I would like the "active" field to populate whenever a status is either In Progress Review Sign Off And when th…
Alight Solutions is seeking a Smartsheet Innovation Specialist As part of our Professional Services - Global Project Operations team supporting deployment of HR and Finance Systems to large and medium…
