Formula help
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
-
Try this...
=IFERROR([2nd network helper column - do not delete]@row, "")
-
Paul - you are my hero. I can't tell you how many iterations I had tried of that. It works perfectly. THANK YOU!!!😀
Answers
-
Try this...
=IFERROR([2nd network helper column - do not delete]@row, "")
-
Paul - you are my hero. I can't tell you how many iterations I had tried of that. It works perfectly. THANK YOU!!!😀
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!