#INCORRECT ARGUMENT SET

Mike Ferringer

I have noticed some unusual behavior beginning on August 8th with a cell containing a complex formula. The formula initially returns the correct result but after saving the sheet, the cell changes and displays the error #INCORRECT ARGUMENT SET. When I open the sheet again, the error message is immediately replaced by the correct formula results (and listed in Cell History as being modified by "Cell Link".) This repeats every morning just after 1 am during the regular Smartsheet refresh. This solution has been in place for over 2 years and with hundreds of project tool kits provisioned. The sheet is part of a blueprint generated through Control Center which has not been modified so the formula in that cell has remained constant. The behavior and error message seem to trigger once the sheet is opened and a cell is modified which would impact the formula. Anyone else seeing odd behavior like this?

Darren Mullen

@Mike Ferringer I've seen some funny behavior with cross sheet formulas like that where even though there is automation activity in the sheet, it didn't update properly until I was in the sheet and saved it….

When Smartsheet had the major outage some weeks ago I had to open and save several sheets to get the cell links and cross sheet formulas to refresh…..

Wonder if it's something like that… I'd suggest screen recording the behavior and submitting a support ticket to see if they can dig deeper into it.

Mike Ferringer

Thanks @Darren Mullen for the quick response. I did submit a support ticket at the same time I posted the question to the Community (I always get better response from the Community). This one is strange. The error cycle only begins when the results change in the cell containing that formula. Hopefully Smartsheet Support responds in a timely fashion. Thanks again!

joshuariedesel

@Mike Ferringer did SS support get back to you with a remedy on this? I am having the same issue with a sheet formula I created yesterday. Formula works great when in sheet but then eventually errors with incorrect argument until i go back into the sheet formula refreshes with correct data then i save sheet and all good until it breaks again…

Mike Ferringer

@joshuariedesel I worked with SS Technical Support and the problem was remedied. They told me that they:

"ran a forced refresh of inbound and outbound cell links in the backend, which helps to propagate data for all the downstream grids. From the conversation, it looks like this has helped refresh stale data and update the cell links with the correct values."

I have not had a similar incident occur since then.

Hope this helps a bit. I feel your pain…This was a frustrating ordeal.

Good luck!

joshuariedesel

Definitely frustrating; I'll reach out to SS Tech Support and ask them to do the same for me :) Thanks a ton for sharing your solution here @Mike Ferringer. I am definitely relieved that this can be remedied!!!