-
I've denied a request, how do I give feedback to let them know why?
Where or how can I let the person know what they need to fix on their request from smart sheets? I thought a pop up would show up once I denied the request to provide details but that just completed the form
-
Can you export multiple sheets at once?
I know you can export a sheet one at a time but is there a way you can select them all and export them? If so how?
-
If Row is not empty, then cell equals value from another sheet
I'm having trouble getting the =IF(NOT(ISBLANK… formula to work. I have a sheet (Sheet A) that automatically pulls data in from another source. I have added a column to that sheet to reference the project name which is stored in another location. My goal is that if a row is automatically added to Sheet A, then the Project…
-
Removing semicolon and pull multiple values from reference sheet
Hi, I have two sheets: Sheet 2 (reference sheet, see photo 1) and Sheet 1 (formula sheet, see photo 2). I've created a formula that works when the item number column is a dropdown menu with multiple selections. However, I need a formula that achieves the same results when the item numbers are separated by semicolons ";" in…
-
Form Automation - linked to another sheet
Hello, We run a few weekly programs at our non profit where there are different volunteers in each of them. We currently have a form on Smartsheet called a Communication Log that the Supervisors have to fill out every week. In their Comm Log, there is a dropdown list that they can select which program they are submitting…
-
Data Shuttle isn't running - what am i doing wrong?
Hello, i have an upload data shuttle set up to run on attachment. i cannot get it to run. i need help to know what i am doing wrong.
-
Help on INDEX and MATCH function
I have tried the INDEX and MATCH function in a number of ways and cannot get it to work. I have read the numerous posts but not getting it. Sheet 1: Appointments Field in Sheet 1: MRN *one MRN can have multiple appointments. Sheet 2: MRN Additional Information Fields in Sheet 2: MRN, MRN Language *MRN is unique ID in this…
-
Calendar app filter
Hi there, I create a data sheet that connect to calendar app. I have a column with checkbox. is there a way that if I check the box in that column the data on that role will show in calendar app thanks, Jess
-
Bridge: Move select columns/attachments/comments to another sheet
Hello all! I'm looking to see if a Bridge workflow can be done with moving/copying select columns from one sheet to another BUT also bringing their attachments/comments over as well. I've made a workflow to copy select columns from a source sheet to a targeted sheet but never have the comments/attachment follow. I have a…
-
Auto Numbering and Formula usage of Auto Numbering
I have 2 different scenarios and need some one to help, If I am using auto numbering tool for a particular column, the list will be in sequential order. Incase, I insert a row between the auto numbers, how it will respond ? Don't want the existing number to change. If I am using the formula to auto number based on some if…