Shawn R’s Profile

Community member since September 2016



I've got a basic handle on VLOOKUP but what I am trying to do is a little unconventional due to sheet row limitations within smartsheet.

We have a sheet in which people will fill in a part number, each part number has a part description. What I want to do is automate the part description field. So I


I would like to write and IF formula in one column that involves 3 other columns. I'll do my best to explain what I am trying to do and the issue I am running in to.

The first column is called "Building" and this is where I am writing the IF formula. The second column is called "Work Center" and its