-
Multiple nesting help!
So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
Cannot find new address for a contact from an automation or sheet
We did not want emails to go to external contacts, so "tricked the system" by creating contacts with the same internal email address: eg. Contact 1 : contact1@internalemail1.com Contact 2: contact1@internalemail1.com Recently, smartsheet blocked this approach and does not let us create multiple contacts with the same email…
-
Copy automation causing mismatched rows
Good afternoon, Can anyone explain to me how to avoid this issue when doing sheet to sheet copy automations? I will provide a screenshot below. It seems that I will put something on sheet 1 and when I refresh sheet 2, it is further down.
-
Is it possible to automate link creation between 2 smarthsheets?
Regarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added to the que 2 or 3 times a week. Is it possible to have two "master" smartsheets linked to each other that can be copied and…
-
Automated Workflows - Notifications not sending on Teams nor Email
Good morning everyone and happy Monday, I have been trying to sent automated notifications for my smart sheet but I can't seem to get it right. The smart sheet is shared in a public workspace and everyone in that workspace has permission to view/edit the cells. When the conditions of the workflows are met however... I…
-
Copy Automation
Does anyone know of a way to use the copy automation without copying EVERY column of the original sheet to the new sheet? Also, can I make it so that the sheets constantly create themselves every week while constantly updating the corresponding sheet using automations?
-
Automatically generate parent row with child rows via form?
Hi! I'm trying to modify a form with a simple grid sheet so that the input of new information via the submission of the form will cause another sheet to automatically generate a blank parent row with (1) the information from the original form and (2) attached child rows. In other words, the ideal final process would be:…
-
Automation Issues
Good Morning Everyone, Happy Friday, I am relatively new to smart sheets and had a question in regards to the automation feature. So I have this sheet specific to techs out in the field and once they fill out what they are suppose to, they are able to check off a box for completed work. That will automatically trigger the…
-
Including Row Comments in a Message Only Alert Someone Notification
I have a scenario where I use the Alert Someone Workflow action, but have it configured to include message only. This is because the users that I'm alerting do not have view or edit access to the sheet. They simply enter requests via a form and receive a receipt of their submission and a notification when the request has…
-
Automated Workflow is saying it's triggered but not sending email/showing up in updates list
Hello, I have created a few automated work flows that are to go out monthly. The automation went out just fine last month, but now after updating the information to be the next month, it says it was triggered, but does not show up in the Update Request log. I set up a whole new workflow as a test and neither of the…
