-
Globle contact list
Hi everyone Any way to have a contact list shared with two or more licensed users? We have contractors’ employees and often they change email address or newly added. When user-one adds a new person too their contact list it does not appear on the second user’s contact list. Joseph
-
Auto numbering based on values from an adjacent cell
Hi Community, I have the below sheet: The value in the "State Code" column should take the State Abbreviation and add the next number in the sequence of that particular State. Anyone know what the formula would be to enable this? Many thanks, Ahmet
-
Forms - can you make formulas on dates?
can the sheet have a formula when the form selecting a date - gives a response? =IFS([@Response]="", " ", OR(WEEKDAY([@Response])={1,7}), "That is a weekend date. Please select a different date.", OR(WEEKDAY([@Response])={2,3,4,5,6}), TEXT([@Response], "dddd")) where the form entry will prompt a new suggestion?
-
Trigger Approval Request with the submission of an Update Request
Hi I have an approval process which sorta works well which allows an approver to decline a request asking for more information. The re-trigger to the original approval workflow is based on the user updating a 'different' do you want to continue? field in the update request form. The 'different' field is then used as the…
-
Link to another sheet and conditionally output
Hello, I have one sheet that I am trying to link to and output data conditionally. There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF". Is there a function I can use to bring in this data? See…
-
COVID Labor Pool
Does anyone have a COVID Labor Pool template available that you are using and is found to be useful?
-
Automation Problem - Alert is not working
Hello Team, I created an automation to request a "request" and send an "alert". The request is sent normally, but the alert doesn't work. Does anyone have an idea of what it could be? Thanks.
-
Can Smartsheet schedule and send content in cells as emails?
I'm looking to recreate this but utilizing Smartsheet and I want to know if it is possible? Schedule & Send Email in Spreadsheets Schedule & Send Email in Spreadsheets Schedule and automatically send emails after exporting your Google Sheets data on a recurring basis. Convert your sheets as PDF, XLSX, ODS or CSV. Save it…
-
Barcodes and UPC's
Consider this a giant bag of worms that I am opening! I am interested in how others are using the Mobile App for UPC's and Barcodes. We are using it for a basic search function, but I am interested to hear about (or maybe even see) how you are applying this to more advanced business functions or maybe even customer…
-
Workflow notifications
I've sent emails to collaborators informing them of their access as well as sent the collaborators requests for approval via workflow. Not all of the collaborators have received emails from Smartsheet. All the collaborators have been set up in my contacts. Is there an additional feature I need to activate for all the…