Formula Question  Blank Needed for a Writein Value
Hi All,
I'm trying to write a formula that will return a blank value (or empty cell) that I can add a "writein" value  which will be different each time the blank occurs. Is there a way to do this, or does the blank that I'm asking for ultimately have to be "blank"?
=IF([Alpha3 Code]@row = "Other", "", IFERROR(VLOOKUP([Alpha3 Code]@row, {Country Codes Alpha2 & Alpha3 Range 1}, 2, false), ""))
Thanks in advance!
Answers

@Seatora The only way to do this, and use a column formula, is to create a second, helper column where the write in value goes. so the formula would be like this
=IF([Alpha3 Code]@row = "Other", [helpercolumn]@row, IFERROR(VLOOKUP([Alpha3 Code]@row, {Country Codes Alpha2 & Alpha3 Range 1}, 2, false), ""))

Hi @Seatora,
If you mean you want to go back into that cell and add in the "writein" value, you can't do that as you would overwrite the formula (in fact, it won't let you if it's a column formula).
One work around might be to put the writein value in a separate cell and reference that in the cases where it would have been black. It will still be blank until you add data to the other cell. Just a thought  untested.
Hope this helps,
Dave
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 438 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 451 Show & Tell
 30 Member Spotlight
 1 SmartStories
 282 Events
 32 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!