-
FORMULA: Conditionally Format Cells with Errors
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 any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
-
How do backups work and can I pull one from a specific day?
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 all of this information is submitted via a form, but I don't manage this grid. I know how to select the grid and say pull a…
-
Feature: Enable Conditional Responses to Different Formula Errors in Smartsheet
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 is. It would be great if we could recognize different errors like #BLOCKED, #UNPARSEABLE, #DIVIDE BY ZERO, and others.…
-
What's your Best Error Checking Column Using Formula?
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't provide the type of details I want. Example: =IF(ISERROR([First Column in Sheet]@row:[Last Column in Sheet]@row), 1) This…
-
Formulas with INDEX and MATCH function now showing #NOMATCH
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?
-
FORMULA COLORS: Color Correct Part of Formula and Gray from error part forward. Don't Grey it all.
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 formula: However, It would be VERY VERY VERY VERY VERY helpful if you could keep the PROPERLY referenced cells in color, and ONLY…
