Reference data to pull from another sheet

Aatish Chaudhary

Aatish Chaudhary ✭✭

07/11/22 in Formulas and Functions

Dear Smartsheet community,

Can someone please help me to get the correct formula to pull the Emp.Names for each department from Sheet 1 to Sheet 2.

0 ·

Answers

Matt Johnson ✭✭✭✭✭✭

07/14/22

Hi @Aatish Chaudhary
If creating a Report would be acceptable, the Group feature would give you exactly what you are looking for.

I hope that helps.
Matt

Matt Johnson
Sevan Technology
Smartsheet Aligned Partner
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Weird Formula Help
I have the following columns in my sheet: Is This An Object? (a drop down "Yes" or "No" column) Object # Box # Folder # HW ID I need a formula for the HW ID column that mirrors the "Object #" IF the "Is This An Object?" cell is "Yes". However, IF the "Is This An Object?" cell is "No", then I want the HW ID column to…
Vlookup - #unparseable result
I built a tracker that is populated with an intake form. One of the criteria is a broker code, that when entered on the tracker from the form, is vlookup’d from a reference sheet and gives me the broker’s name, their branch code and branch name. This works perfectly fine for our purpose. Our team has now been tasked with…
Milestone Report
How do I get this calendar on the right no to show? I'm using a report to pull this info This is what my report looks like