-
Extracting text from a multi-select drop down column
I have an intake sheet where one of the fields is a multi-select drop down list. The values in the list are NUMBERS; TEST NAME. I want to be able to parse out just the number into a separate column in the intake sheet as someone submits it, so there'll be a populated column of Test Code Intake that has the NUMBERS; TEST…
-
How to get rid of the "Reminder" as the 2nd row in my slack alerts
See screenshots of my automations set up and slack alerts. I want to get rid of: row 2 of slack alert: Reminder row 1 of slack alert: Reminder to schedule testing for BD_Proteinase K (Item ID: RGT0172_01, Lot #: 209482) row 2 of slack alert: Reminder row 1 of slack alert: Reagent BD_Oligo Binding Buffer (Item ID: RGT0173,…
-
Moved: Range of data
This discussion has been moved.
-
Remove "Reminder" from slack alert in automated workflow
See my post to the smartsheet community on 12/16/2024
-
Dark Mode for Desktop App
I'm so pleased to see the release of the Desktop App. Such a key feature, so well done. It would be great to have dark mode included in the app.
-
How to perform "IF(ISNA(VLOOKUP.." or "IF(ISERROR(MATCH.." when there are multiple items in cell
The sheets I have: Hospital Notification Survey Form - where Regional Directors attest that they have notified one or more hospitals of the upcoming change (for simplicity, I'll say there's 10 total hospitals) Hospital Notification Tracking Sheet - will track submissions from the above survey form's sheet, which ultimately…
-
Smartsheet Forms Timer Function
Hi all! I am hoping to implement the enhancement of adding a Smartsheet Forms timer function. For my team, we would like to see how long it takes to review and correct settings in platform for various marketing campaigns, which we do through a Smartsheet Form. This would allow us to assess if the process needs to be…
-
Can Update Requests have the same functions as a Form?
Update Request changes certain cells in a row, while Forms always add new rows to a sheet. Yet we need the customization options for Update Resuest compared to the Form: making fields required, help text, logic, etc. Hope it's underway soon!
-
WorkApps: ADMIN/Editor role
We have developed two end user workflows that are based around the work app. As of now I'm the only person who can edit the workapp we are using for multiple locations onboarding tracking. This a huge single point of failure. I should be able to add admins to this app to help respond to access request or help managing…
-
Getting a specified drop down selection based on the range from another cell
I have a sheet that is for prioritization purposes, there are multiple columns that aggregate value into a "Total Score" column, I want my "Priority" column to auto populate a value based on the value in total score ie if value 0-20 it should be P4 if it is 21-40 P3 if 41-60 P2 if 61-80 P1 if 81-100 P0. I used the…
