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!

Find more posts tagged with

Accepted answers

All comments

Samuel Mueller

@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), ""))

DKazatsky2

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.