Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Can Assign People workflow add "current user" to contact cell in the Actions?

I would like to automatically populate a Contact Cell Column (called Associates) with the current user when they fill in a row. It does not seem possible and I am wondering if I am missing something. My workaround is using a fx in my contact column that basically says =[Modified by]@row.

But I'd prefer an automation if I could since my workaround populates my Associate cell with email address and I prefer to see person's name. Not a huge deal, just wondering if it was possible. Thanks!

Best Answer

  • Community Champion
    Answer ✓

    Hi @Susan Vieira

    I hope you're well and safe!

    Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

    Please submit an Enhancement Request when you have a moment.

    Here's a possible workaround or workarounds

    • Please have a look at my post below with a method I developed.

    More info: 

    Lock or Store Date/Value Solution without using Zapier

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions