-
Condition code to include dates in serial order
Hello mates , I want to make automation that take effect on condition if dates reached after 2 days to 20 days I listed all dates seperating them with comma (,) . is there a short code or formula to include all these days ( weeks or months as well ). I tried 2:20 and 2-20 and it did not work 😔 Thank you, in advance for…
-
Creating a Rule to Automically Hide Rows
Is it possible to create a Rule, Conditional Formatting, or Workflow where when you check off a Box on the sheet it then hides that row? If not, can I request this feature from SmartSheet? Thank you
-
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…
