Smartsheet Fails Often

BullandKhmer · 04/26/23

And it really annoys me. Wasted four hours of my life today on a simple INDEX(MATCH()) for no reason.

Here is my source sheet:

Here is my destination sheet:

Here is my cross sheet formula:

=INDEX({JOB_QuoteNo}, MATCH([Draft ID]@row, {JOB_DraftID}, 0))

And yes, the cross sheet references are mapped correctly. About once an hour Smartsheet agrees with me and populated the column correctly, for about 2 minutes, then reverts back to nonsense.

My options from what I gather are

a) Come on here and ask for a solution, and and ask for answers to an unanswerable question

b) Log a ticket with "Support" and wait two weeks for them them to fob me off with vague statements about complexity and no solutions.

I'm going with option A, any ideas folks?

In my experience this crap happens often and really isn't good enough.

Cheers.

ShelbyWarren · 04/26/23

@BullandKhmerThat's weird. It's working for me when I test it out.

Krissia B. · 04/26/23

Hello@BullandKhmer

I apologize for this experience. At this time, this is best routed to our Smartsheet Support team to further assist with troubleshooting the issue you are experiencing.

Cheers,

Krissia

BullandKhmer · 04/27/23

@BullandKhmer<\/a> That's weird. It's working for me when I test it out.<\/p>","bodyRaw":"[{\"insert\":{\"mention\":{\"name\":\"BullandKhmer\",\"userID\":141676}}},{\"insert\":\" That's weird. It's working for me when I test it out. \\n\\n\"}]","format":"rich","dateInserted":"2023-04-26T21:46:47+00:00","insertUser":{"userID":157684,"name":"ShelbyWarren","title":"Systems & Processes Project Manager","url":"https:\/\/community.smartsheet.com\/profile\/ShelbyWarren","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZsElWRv5fWo!urkpJ-Oilro!MkuJ6upsrhT","dateLastActive":"2023-04-27T19:16:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373481#Comment_373481","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/373481#Comment_373481

Hello @BullandKhmer<\/a> <\/p>

I apologize for this experience. At this time, this is best routed to our Smartsheet Support team to further assist with troubleshooting the issue you are experiencing. <\/p>

Cheers,<\/p>

Krissia<\/p>","bodyRaw":"[{\"insert\":\"Hello \"},{\"insert\":{\"mention\":{\"name\":\"BullandKhmer\",\"userID\":141676}}},{\"insert\":\" \\nI apologize for this experience. At this time, this is best routed to our Smartsheet Support team to further assist with troubleshooting the issue you are experiencing. \\n\\nCheers,\\nKrissia\\n\"}]","format":"rich","dateInserted":"2023-04-26T21:58:10+00:00","insertUser":{"userID":116817,"name":"Krissia B.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Krissia%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n9SCK0BN9D6E5.png","dateLastActive":"2023-07-21T20:30:02+00:00","banned":0,"punished":0,"private":false,"label":"Moderator"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373486#Comment_373486","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/373486#Comment_373486

This is EXACTLY my point. Yes, this should always work, it simple index match formula. But it doesn't. This happens often. And my only options are

a) to ask a question on here, that frankly can't be answered other than to say "that's weird, that should work"

OR

b) contact "support" who take two weeks to respond, often with a non-answer or non-resolution.

Lift your game Smartsheet.

BullandKhmer · 04/27/23

Logged a ticket with support, still waiting 12 hours later.

ShelbyWarren · 04/27/23

@BullandKhmerSorry you're experiencing issues. My response above was from me directly, Smartsheet had nothing to do with my answer.

Thanks for the tip. Hope it gets worked out for you.

BullandKhmer · 04/27/23

@ShelbyWarrenI know mate, I'm not having a dig at you. You just happened to help me make my point.

BullandKhmer · 04/28/23

Logged a ticket 44 hours ago, no response from Smartsheet "Support" to date.

BullandKhmer · 04/29/23

Logged a ticket 64 hours ago, no response from Smartsheet 'Support' to date. Seems inevitable that we will miss our launch date on Monday morning over a very simple index match function.

BullandKhmer · 04/29/23

Righto, I think I've worked around this myself... here is the incredibly stupid thing that shouldn't have worked but did.

My source COLUMN used the formula =IFERROR(INDEX({XQU_QuoteNo}, MATCH([Xero Quote ID]@row, {XQU_ID}, 0)), "No Quote")

I changed this to =IFERROR(INDEX({XQU_QuoteNo}, MATCH([Xero Quote ID]@row, {XQU_ID}, 0)), "")

and the I changed in back to =IFERROR(INDEX({XQU_QuoteNo}, MATCH([Xero Quote ID]@row, {XQU_ID}, 0)), "No Quote")

Obviously this is absolute nonsense. I think I've wasted 11 hours on this crap already. Still waiting for "Support" to be supportive or at least acknowledge my ticket.

LIFT YOUR GAME!

BullandKhmer · 04/29/23

HAHAHA.... sadly I spoke to soon. Ive gone back into the sheet after making the above post and the issue persists, FOR NO APPARENT REASON.

BullandKhmer · 04/29/23

Honestly, this crap is making me crazzzzzy and I'm really disappointed in Smartsheets so called support.

Here is another stupid thing I tried today... In my source sheet I added a new column, Quote No 2, and added the following formula:

=INDEX({XQU_QuoteNo}, MATCH([Xero Quote ID]@row, {XQU_ID}, 0))

Then I changed the Source Sheet Quote No column formula to

=IF(ISERROR([Quote No 2]@row), "No Quote", [Quote No 2]@row)

Did it work - Yes! for like 1 minute. But then it reverted back to the same old crap where every row just says "No Quote"

It just doesn't make any sense, its a complete waste of my time.

Smartsheet support is non-existent, think I'm at 70 odd hours with no acknowledgement of this issue. We NEED to go live Monday morning AU time and this nonsense is preventing that. Completely unacceptable stuff.

BullandKhmer · 04/30/23

Contacted Smartsheet's so called "Support" 85 hours ago, no response to date.

BullandKhmer · 05/01/23

It's a century! Logged a ticket with the so called "Support" 110 hours ago. No response whatsoever, not that I'm surprised.

We have missed our launch date, over what should be a simple issue to resolve. Now we have to wait around twiddling our thumbs until Smartsheet decides to provide some real support for their product.

Thanks Smartsheet.

BullandKhmer · 05/02/23

Up to 130+ hours waiting for Smartsheets so called "Support" what a bloody joke. No response.

Frankly, we work on both Smartsheet and Airtable and usually promote Smartsheet as our preferred platform when possible. Now we are thinking we can no longer take that risk commercially. We can afford to take the risk of a minor Smartsheet issue derailing our entire program, with NO SUPPORT offered and no avenue to resolve the issue in a reasonable timeframe.

If you go on Smartsheets Facebook page the ONLY comments are people complaining about Smartsheets lack of support and a poor Smartsheet rep apologizing for that fact. Stp paying people to apologize and pay them to do something useful.

BullandKhmer · 05/03/23

在几个小时的时间,我将完成1周的等待ing for Smartsheet "Support". In that time I have made multiple attempts to contact Smartsheet through this post, another post, the "Support" ticketing system, facebook etc etc. I've been apologized to at least four times but nobody has actually got around to doing something about it. When was the last time you had a conversation with Smartsheet support that didn't start with an apology? Of course these apologies are disingenuous and its apparent that it is Smartsheets business model to under resource the so called support service.

We've missed our deadline, lost some reputation points, and have been forced into doing 2+ days work for free to install a temporary solution, all over a simple index match formula that doesn't work as expected and should be resolved promptly. Its frustrating and embarrassing and I'm seriously considering promoting rival software's for future projects, despite encouraging all clients to use Smartsheet for the past 18 months.

Thanks Smartsheet. thank you so much.

Smartsheet Fails Often

Answers

Help Article Resources

Categories