Sign in to submit new ideas and vote
Get Started

FORMULA COLORS: Color Correct Part of Formula and Gray from error part forward. Don't Grey it all.

NeilKY
NeilKY ✭✭✭✭✭

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 gray out where the formula starts to break. This would be A-MA-ZINGGGG!

My current annoying workaround is to paste part of the non-working formula a little at a time and see which "paste" instance breaks it. The problem with this is that when I press enter, smartsheet might add a ")" or replace the last symbol to finish the formula for you, and I don't always see it before returning and pasting the next part of the formula. Or, I paste in the wrong section of the formula accidentally.

My official Feature Request is to:

Color the formula in a cell until the part where it breaks, then make the rest of the cell black and white.

-Neil

1
1 votes

Idea Submitted · Last Updated