-
how to resend an approval notification
I need to resend a approval notification if its not approved in 2 hours.
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
Copying a cell with an auto number from one sheet to another overwrites existing auto numbers
Hello, I'm using two intake sheets for different project types. Each intake sheet is populated by an idea submission form and the entries receive a unique number with an Auto Number column. So far so good. Situations come up where a project of type A needs to be moved to type B. We do this with a checkbox, which when…
-
Executing multiple conditioned automations with one trigger.
Hey Folks, Basically, I am looking to use an automation (or other tool) to check and fill multiple cells based off of a single checkbox. Specifically: When ticked, check Col 1, if Col 1 is empty, write HELLO. Then check Col 2, if Col 2 is empty, write HELLO. Then check Col 3, if Col 3 is empty, write HELLO. And so on. The…
-
Automations not being consistent - sometimes running, sometimes not
Kia ora, I've got an automation set-up on a sheet when certain criterion is checked on the row it will send an email to a particular person (with the data on that row). I've tested it numerous times to get it right and it's worked fine, however using the sheet today, it worked once, but that's it. I tried changing the…
-
Automate a sql query of public information to merge with Smartsheet
Hello! I'm seeking steer on an automation. I am manually mining publicly available data (ClinicalTrials.gov) using a query of this database - - and I merge the results into my sheet via a data shuttle upon attachment to the sheet. At present, I do this about once a month (or whenever I think about it). I would like to…
-
Merged: Timestamp Automation
This discussion has been merged.
-
Copying a Checkmark Field from one to another on the same sheet.
Hello, I have a process set up where I pull data in from another sheet, and then I have a handful of Columns with formulas that will fill with a Check or Uncheck based on the information in the data that was pulled in. My goal was to be able to use these Checkbox columns to track processes, but since the columns are locked…
-
Improved User Auto-Provisioning
It would be great to be able to specify some additional options for user auto-provisioning: Have the ability to add auto-provisioned users to Groups automatically - Being able to add new users to an "All Employees" group automatically would mean they could have access to some resources by default. In my case, users…