-
Contact not populating correctly in automated workflow?
This is a cosmetic issue only, but it’s important to the person being singled out. I have a list of supervisors who get assigned when incidents are submitted. There’s an automated workflow that assigns the supervisor based on certain criteria. The assignment column has all the contacts with names and email addresses.…
-
Sort based on last name
I know this is a SIMPLE question, but I couldn't figure out how to do that. I have a column that consists of contacts, but I want to sort it based on the last name, not their first name. How would I do that?
-
Add Main Menu to WorkApps
It would be nice if the main menu in WorkApps included the same menu choices as core Smartsheet. For example, if a user who ONLY uses WorkApp needs to add or edit either a contact or their notification settings, I have to coach them to leave WorkApps and go to Smartsheet home. This is all you get in WorkApps, as opposed to:
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Use Contact List (formatted column) as data source to lookup info
I have spent several hours searching for an answer to what I think should be something simple to do. I have a sheet with information related to a contact, (address, supervisor, ph numbers etc). All I want to do is reference the name in the Contact List (formatted column) to pull up other information related to that person.…
-
Only Unique Contacts Formula
I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert…
-
Alert/Notification when line item hasn't been added
I am building a sheet in which 6 managers provide updates in the form of line items. Each week our Director reviews this sheet for the latest updates. I am looking to create a notification system that would go out to each manager that doesn't provide at least one update (add one line or modify an existing line) in the last…
-
Cross-Referencing Assigned To Error
I am building out a roll-up sheet and have everything working nicely, with the exception of a single formula. The part of this sheet I'm having trouble with is in the image below. What I am trying to do is have this sheet look at the person named in the column "Primary", then check a couple other sheets to see how many…
-
Automations when selecting from contact dropdown
I created an automation to move rows to a specific person when they are selected from a contact drop down. I have more of these to building, with different automations such as copy a row when they are selected from an other drop down. I also need to add a notification when each of these process have run. I attached what I…
-
Automation workflow assigning people in a Contact List column - list doesn't match
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…
