-
Unable to remove user available in a SmartSheed Contacts list
I created a Contacts list column that additionally had 4 people including myself. I then created a record as an example, using my name. Subsequently I deleted my name from the list and changed it to only allow the available people in the list to be selected. Now I do not show up in the column properties list but still show…
-
Fetching comments from a Smartsheet : Getting Error
unction comments() { const apiKey = 'API KEY'; // Your Smartsheet API token const sheetId = 'SHEET ID'; // Your Smartsheet sheet ID const baseOptions = { method: 'GET', headers: { 'Authorization': 'Bearer ' + apiKey }, muteHttpExceptions: true // Allows us to inspect error responses }; let allComments = []; // Array to…
-
API errors intermittently but often
We use different providers like Make, Zapier and Appsheet etc that connect with smartsheet, but lately we are getting SO many errors, from connection errors to 'Unable to update row in table unexpected error', 'the service is currently unavailable please try again later', 'table is not accessible please try again later,…
-
"Something went wrong" when accessing Admin Center
I signed up for a Business Plan today and I am not able to use the Admin Center. I was trying to add members, but it's not allowing me to do anything and I get the "Something went wrong" error box when I enter the Admin Center tab.
-
Error message when opening a sheet
Recently started having trouble opening some sheets on my account. Thought I may have gone over some limit or something so I upgraded. I also added a licensed user to be available for a new avenue I'm taking with my job. I am still getting the an error message. Status shows that the site is operational. Message states…
-
=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,…