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

Nate Ensor

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.

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)

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 Ensor

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?