-
Is there a way to set custom number of days to a trigger?
I see an option for 90 and 180 days before. but need something that falls in between
-
Copy rows to another sheet - attachments not copying
I've got an automation which copies a specific type of invoice to another sheet once approved. On other similar automations the attachments go across no bother, but on this one it worked once and then stopped! Any ideas?
-
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?