-
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…
-
WorkApps Loading Error
Hello all - Over the past couple of months I've received errors like this image below when just opening a WorkApps. "ErrorPage, URL is not valid" Either directly from a bookmark or by clicking the icon on the left side and locating the app to open. Has anyone had this error before? My only workaround is opening a private…
-
Need help with this simple formula
What am I doing wrong…..maybe the placement of the formula?? I've tried placing in the "Status" field and get a circular error… =IF([% COMP]@row = 100, "complete", [Status]@row)
-
#INCORRECT ARGUMENT SET
Hello! I have a cell in one sheet that has 3 if statements. This cell is populating a value with no issues. Then I have a vlook up in a different sheet that is giving me the #incorrect argument set. I know the formula is correct because it is the same as I'm using in another cell with just the column number changed. Anyone…
-
Attach File on Schedule
Can Smartsheet, on a schedule, pick a file from a SharePoint folder and upload it as an attachment to the sheet?
-
Summary Sheet Not Connecting to Correct Column
I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). In my summary sheet, the columns that should be looking at the text/number column for data are looking at the contact column…
