Formula to reference sheet only if blank and certain conditions met.


How can I reference another sheet for names?

I have a grid for current positions, some are filled, and some are not. For those that are not filled, column "Employee name" is blank and for those that are filled, column "Employee Name" is not blank. I have another grid with vacant positions only and it notes candidates' names. Both grids have the position number as the primary column. I need to set up the "current positions" grid to pull the name of the "Candidate" column from the "vacant positions" grid only if they have a start date in the "start date" column. So, ultimately, the grid for "current positions" will only pull a name from the "vacant positions" grid if the current positions grid "Employee Name" column is blank. If the current position column Employee Name is not blank, then leave the current name



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!