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.

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions