How do I copy a contact field from the PARENT row to the CHILD rows to be a contact field?

I am trying to create and apply a filter that will show current user view when the user is listed in the Hiring Manager column. I created a cheat column ([CHEAT - HM]as a contact type) and used every formula I can think of to bring that info down to the child level, and reside in the [CHEAT - HM] column. It works, but it is not a true contact and wont show those CHILD rows when I apply the filter. Any suggestions?



Best Answer

  • Lisa Bryant
    Lisa Bryant ✭✭
    Answer ✓

    Ryan, it was almost that simple. The cheat column was a contact column, BUT the other column allowed multiple contacts. As soon as I changed the cheat column to allow the same, my whole world changed! Thanks for your help.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!