-
=IF(AND(OR(HAS Column Formula with 3 results (option 1, option 2, both) #INCORRECT ARGUMENT SET
I have a search range which is a column that has up to 35 bus routes. The bus routes are operated out of one of two facilities, "ARCADIA" and "POMONA". I am trying to create a column formula that will return a result of "ARCADIA", "POMONA", or "BOTH". I can successfully create a column formula that will return one of those…
-
Dynamic View Issues
Is anyone having trouble with their Dynamic Views today? I'm getting: "Bad request. Report mapping doesn't exist. and Error. We ran into an error loading your Dynamic View. Please refresh the page and try again. If this error persists, please contact support." I recreated my DV and it still brings the same error codes. The…
-
Unexpected behavior on Form
Hi All, We are experiencing some unexpected behavior using forms that started this morning and is causing absolute chaos in our org. We have been on Smartsheet for about 3 years, and rely heavily on forms for kicking off client projects. Many times the same form will need to be submitted multiple times with small tweaks…
-
ERROR: The row you are trying to access is no longer available
This week, I'm suddenly getting a popup error stating "The row you are trying to access is no longer available" upon opening of a Sheet. This sporadically happens on a couple of sheets but not all. No filters are set upon opening. Anyone else? Any ideas how to make it stop? Thanks in advance!
-
Using Collect to pull data from the same sheet
I usually use Index(collect to reference separate sheets to pull data, but I'm trying to apply the same logic for pulling column values from the same sheet. I tried this as an Index(collect formula =INDEX(COLLECT([QTY on Order]:[QTY on Order], [Ref PN 1]:[Ref PN 1], [Part Number]@row),1 & a collect formula on its own,…
-
Strange INVALID VALUE error
Hi everyone, I've encountered a problem in Smartsheet that I tried solving for a long time without success. I was creating metrics for a sheet, and I made a bunch of summary fields that contained my formulas. They all worked as intended when I created them. About a month passed without anyone touching them, I went back to…
-
INDEX COLLECT function returning #INCORRECT COLUMN VALUE
I have a sheet that contains the info of all of my employees which includes a column for their initials. The training department of my company has a sheet that I have view access to but not editor access. They track the qualification due date of all of my employees and I want to collect the due date on my employee info…
-
Selected data cannot be charted - shouldn't be happening
I have a report that I want to use as a data source for a chart on a dashboard. The report has summaries and the required grouping so that the top-level row of data can be used for the chart. Even though there clearly is numerical data for a chart to be created (see below), I am getting the error - "Selected data cannot be…
-
Dynamic View in WorkApps Error
As of this morning when trying to load up a dynamic view in the workapps on Iphone, in error is displayed at the top of screen stating: "Unexpected input on Byte 1". This is happening with multiple users including myself. I have tried different dynamic views with different data and are getting the same results.
-
Email Error
I have an automation set up so when a certain column is checked it will generate a document via DocuSign. It worked perfectly and now suddenly I keep getting the same error. I have scrapped the automation and started over making sure everything is set up correctly but still get the same error: The email for "Doctor Email"…