Automatically Select Contact With Column Formula


I am fairly new to smartsheet so I apologize if this is a basic question.

I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from many sheets, a filter that only allows a row assigned to a contact to be shown can be applied.

I understand that when referencing a contact in a formula, you have to reference a contact cell that has been manually selected. For example you couldn't select a contact with the following formula:

IF([Task Name]@row, "Eric")

Since this would just print Eric and not select the contact named Eric.

To populate all the rows that aren't empty I used the ISBLANK condition and I tried to create a column formula that referenced a filled out contact cell in another column:

IF(ISBLANK([Task Name]@row), " ", Contact1)

But it gave me an error because you can't select to always reference a single cell in a column formula and it has to reference a cell @row.

Finally the only solution that worked was to create a separate "Contact Book" sheet which had a filled out contact cell:

=IF(ISBLANK([Task Name]@row), " ", {Contact Book Range 2}

This seems crazy that I have to create a separate sheet to reference just to populate an entire column with the same contact. Is there something I'm missing, or any easier ways of accomplishing this?

All help is appreciated!


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Eric Strashin

    I hope you're well and safe!

    You can use the Sheet Summary feature, and link that to the column, and make it a column formula.

    Make sense?

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.