Greetings, I'm having a weird Smartsheet issue reported today where a bunch of rose have the same description from a previous row and they're not supposed to. I'm not sure how this happened because al…
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at …
I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it …
I have discovered multiple ways to create a error checking column that looks in all columns to see if there's a broken formula somewhere. However, all the ways I have found aren't very elegant and don…
All of my columns that are using the INDEX and MATCH function are now showing as #NOMATCH. was there a change made in Smartsheet? what will i have to use now instead?
I LOVE that when you are writing a formula in Smartsheet, the formula adds colors to the references as you make successful references to cells. And how it goes "Grey" if there's a problem in the formu…