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

Options

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.

Tags:

Best Answer

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Answer ✓
    Options

    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)

    👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

    PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

Answers

  • SoS | Dan Palenchar
    SoS | Dan Palenchar ✭✭✭✭✭✭
    Answer ✓
    Options

    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)

    👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.

    PS - If you have a follow up response use @Dan Palenchar so I get notified of your reply!

  • Nate Ensor
    Nate Ensor ✭✭✭✭✭
    Options

    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!