Contact List Formula


I have a column in a sheet that I named Assigned To. It pulls a contact based off an IF statement dependent on another cell in the sheet. The formula works properly and plugs in the contact appropriately with their icon as well.

I have another sheet that pulls together all tasks based on the Assigned To columns. It works perfectly and pulls from every sheet except for the one I mentioned above. Is there an issue with pulling from when the Assigned To is with a formula? Does anyone know how to resolve this?

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!