Formula Question - Blank Needed for a Write-in Value
Hi All,
I'm trying to write a formula that will return a blank value (or empty cell) that I can add a "write-in" 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([Alpha-3 Code]@row = "Other", "", IFERROR(VLOOKUP([Alpha-3 Code]@row, {Country Codes Alpha-2 & Alpha-3 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([Alpha-3 Code]@row = "Other", [helpercolumn]@row, IFERROR(VLOOKUP([Alpha-3 Code]@row, {Country Codes Alpha-2 & Alpha-3 Range 1}, 2, false), ""))
-
Hi @Seatora,
If you mean you want to go back into that cell and add in the "write-in" 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 write-in 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!