-
How to stop Auomations from combining two form entires
I have a Smartsheet form that when submitted triggers and automated email. However, if two forms are filled out within a minute or two of each other it combines both entries into one automated/combined email that is sent out. I want each form submitted to have its own automated email, how do i turn off the "combined"…
-
View Only Access to Subset of Columns
I'm looking for way to allow a restricted view (sub set of columns) to and an external organization (I've set up a View Only user group). 1st try: Create a report with just the columns - FAIL. I still need to grant the view only permission to the source sheet 2nd: Create a 'query sheet' that 'VLOOKUPS' just the columns -…
-
CONTACTS NAME TO APPEAR IN CELL NOT THE EMAIL
I am trying to run an automation workflow "ASSIGN PEOPLE": Trigger = when rows are changed/TASKS(column)/Changes to/any value/when triggered Condition=TASKS(column)/is not blank Action-Assign people=EXPEDITOR(column)/a contact The expeditor column is set up for contacts. When I run the automation it pulls up their email…
-
Why does my alert keep pulling in the parent row?
I have set up an alert to notify me when a row changes, but instead of it just sending me the rows that were changed, it's also including the parent row (ROW 113 in example), where no changes were made. The 'Objective' column that I'm bringing in uses the =PARENT(OKR@row) formula so that I know which objective the…
-
Check Mark Row
Question- I have 3 check marks within a row. My goal is to figure out a way to have only one of those check marks "checked" at any given time, not multiple. So if one is checked in one column and i check another box in another column then it will remove the existing check mark in the other column. Anyone?
-
Ticket Tracker | Escalation steps after x days | days vs workdays
Hi, hope you can help me again with this issue? We build another ticket system f.e. for new letters coming from various authorities. Depending on importance we want to escalate the working process and send reminders to supervisors f.e. after 2/7/14 days But we need to set working day instead of normal day into the…
-
Approval Request Workflow Hyperlink via Google Integration
Hello, Does anyone know how to include a hyperlink within an approval request workflow via Google Hangouts/Chat? The only solution I have come up with is including the URL into the comments section, but it is not clickable in chat, only email. Otherwise you have to copy and paste it. Thanks!
-
Voting using Symbols Formula
I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I have a "Tally Vote" column that I want to use as a summary of sorts to reflect status at a glance in…
-
Form Link in Automation
Hi, I have a form that I created based off a sheet. I am wanting to send the link to the form in and automatic request from another sheet. What is the easiest way to accomplish this? Thank you!
-
Restricting multiple entry in Forms
Hi Everyone, Is there a way to restrict multiple entry in the forms? Or any way I can set the validity of the form for a particular duration? Regards, Abhiraj Joshi
