-
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…
-
Mark an old submission
Hi, I have a sheet I created where a name and status are being inputted through a Smarthseet form. I am trying to figure out a formula to mark old submissions. Meaning if someone submits a name with the status of "Onboarding" and then submits the form again with the status "Hired", what formula can I use to mark the old…
-
Is there a way to create a list out of joined string in a cell?
I have Sheet A, were I have a column with Task Description that has parents. I created another column where I put the parents corresponding to the child. Example: Parent ID .........|........Task Description [blankcell]........|........Parent 1 [Parent 1].........|............Task 1 [Parent 1].........|............Task 2…