"If" formula - Auto populate a defined text if a cell is blank?

Hello - unsure if I'm even using the right formula here, but I want a cell to populate the word "Requestor" if the cell is blank, and keep whatever is populated... if not blank.

Or is there a way for a column that is currently a single select dropdown to default to the option "Requestor" and then would be changed if needed to another option? I know you can do this in SS Forms.

Find more posts tagged with

Formulas

Accepted answers

SoS | Dan Palenchar

Using a form to have the default value "Requestor" added would work well, this could then be manually typed over.

If you want a formula driven situation, you will need a second column to reference. You can use an IF statement to populate your original column based on the value in that column via

IF(ISBLANK([Column Name]@row), "Requestor", [Column Name]@row)

All comments

SoS | Dan Palenchar

Using a form to have the default value "Requestor" added would work well, this could then be manually typed over.

If you want a formula driven situation, you will need a second column to reference. You can use an IF statement to populate your original column based on the value in that column via

IF(ISBLANK([Column Name]@row), "Requestor", [Column Name]@row)

Nate@E

Unfortunately a form is not the only input device onto this sheet. So I think I need a formulas driven situation.

If using a secondary reference column, that formula populates the reference column, and I need it to populate the column that is showing a blank. Everything I try creates a circular reference.

Any other solutions?

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.