-
I need help and suggestions for creating following sheets:
Hello Community, We would like to create sheets, which will be working for the following functions and trigger the right authority on time: 1. Perform monthly vendor scorecards 2.Have an approved vendor commodity matrix that can be shared with our employees 3. Use for monthly OTD vendor ratings 4. Reminders for ISO and…
-
Lock Cell until conditions are met
Hello, I have a checkbox column called Ready for Production which notifies the relevant persons when an item is checked and ready, I would like to lock or leave cells on this column empty until a number of conditions are met, the conditions are; Drawing Status Column is A - Approved or B - Approved (with comments) Site Dim…
-
Row ID (ignoring blank cells)
I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks entries. (Row ID) I hope somebody is able to help
-
Automated workflow change cell not trigerring
Hi all, I am trying to set up a workflow in a very basic way in a Smartsheet. Basically that would be: When the tickbox is cheched in a field called "done", then change status to "closed. Despite all my efforts the status field remains the same. I am attaching a workflow configuration screenshot: Thanks for your help !
-
Is there a way to set up Cumulative Roll Up Notification Emails
We have a large team all working within a workspace, and they already get a TON of email. Is there a way to set up a single daily notification for new items assigned to team members, without it being an email for each sheet? We have about 10 sheets that are being used, so would prefer not to see users getting 10 emails.…
-
Is there a way to show only the specific fields that have been checked in automation messages?
I currently have a Form set up that provides options when onboarding a new employee. There are recommended and optional options for each selection, because of this I end up with "duplicate" columns which make the Form look and function amazingly. The issue I'm having is that I would like only the checked (☑) selections in…
-
How do I align user's role based on a point in time occurrence?
I manage a vendor relationship that includes tracking the usage of their services on a monthly basis. The vendor services are available to multiple internal groups and part of the reporting is tracking the percentage of total services that each group utilized in a given month. On occasion, a user may transfer to a new…
-
Logos on Alerts
Can logos be added to "alerts" and how? When we send out alerts recipients ignore them because they feel that are phishing attempts because they show as an external delivery coming from my email address. But I want to add our company logo so it will be more identifiable by the recipient.
-
Unlicensed unable to receive verification email
I have an unlicensed user who inputs data into my smartsheet. He is supposed to received a confirmation email once his form submission has gone through with a copy of the data that he entered for his records. He is one of many employees who uses this form but is the only one unable to get the email. I have checked his…
-
Automation workflow: "Too many actions"
Hi there, I got a message from Workflow design workspace stating: "Too many actions" Would you know exactly what limit I've reached that triggered this message ? I can count 34 conditions - is this a limit ? I believe there are 75 actions - counting an email notification to 5 users as 5 actions : is this a limit ? Thanks…
