-
Autosuggest contact names in form
Hi, can anyone help? We have created a booking form to request tickets for an event on a certain date. As part of the booking process, the user can also select up to 17 other (internal) guests to accompany them to the event. I have already configured the following * set the guest column up as contact type * allowed…
-
dropdown list
I have a first sheet name 'customer contact' On other sheet name 'report' where I use the customer contact list to make a dropdown list. My question : It is possible to refresh automatically the drowpdown list when I add a new contact in the sheet customer contact? Thanks per advance for your time and support. Best regards.
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
COLLECT Formula for Contacts
Hi there! I am trying to set up alerts for a smartsheet document to notify any contact that does not have a specific row updated. I have two columns that I'm currently referencing in the sheet, and I'm hoping that I can have a cell return any and all contacts in a column selection that does not have that box check. The…
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace?
-
Calendar App Filters
Within the sheet/report, I have a Contact List column that contains multiple contacts per cell. However, when the Contact List column is used as a filter within the Calendar App, these multiple contacts per cell are not broken out into single values. Is there a way to separate values within the Calendar App filter? Or does…
-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
Multiple approvers on one row
Hello, I am trying to setup an approval that would have 4 contacts that need to sign-off. They are all from different departments, so they would be looking for different things in the approval. I would need all of the approvers to sign-off before the task status changes from "Ready for Approval" to "Complete". Is there a…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
SMART FOR ASSET MANAGEMENT
Hello, Is it ideal/ possible to use Smartsheet in place of CMMS?
