Formula help

Paula Cosentino
Paula Cosentino ✭✭✭✭✭

I have some columns with formulas that pull in information (if information is available).

If the information is not available (filled in), the column puts "#Invalid Value" in that column. Is there a helper row formula I could use to say if the previous column has "#Invalid Value" then enter a space (which I can do) but I can't make it enter the data instead of the space if the previous column has real data. I hope this makes sense ;-O

So on my picture, I want "Secondary Care Site Networks - Do Not Delete" to be blank if the previous row says "Invalid Value" but show the data if there is data in there like the circled cells.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!