Can I use the IF function to access information from another sheet?

Mommaduck
Mommaduck ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

I want to move a file currently in Excel to Smartsheet.  In Excel I have 2 tabs - one where incidents are recorded (call it tab A) and the other that has a list of programs with what division they are in and their staffing set up (call it Tab B).  When I am recording an incident on A, I enter the program name and its division and staffing auto-populate.  Can I do that in Smartsheet?  Would all the information have to be on one sheet?  I've looked at cell linking but the list is long so bouncing back and forth between sheets to copy the info would take too long.

Thanks!

Comments