Weird Formula Help

Nicole J · 09/10/24

I have the following columns in my sheet:

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 display "Box #" PLUS "Folder #".

Thoughts?

Nic Larsen · 09/10/24

Something like this:

=IF([Is This An Object]@row = "Yes", [Object #]@row, [Box #]@row + "" + [Folder #]@row)

Can add a space or a dash if needed between the quotes or take that out depending on needs.

Danielle Arteaga · 09/10/24

Assuming your sheet set up looks something like this:

Put this formula in your HW ID column:

=IF([Is this an Object]@row = "Yes", [Object #]@row, JOIN([Box #]@row:[Folder #]@row))

Note that this works only if [Box #] and [Folder #] are adjacent columns. If they are not, then you'd need a slightly different syntax:

=IF([Is this an Object]@row = "Yes", [Object #]@row, ([Box #]@row + [Folder #]@row))

If you want a delimiter between [Box #] and [Folder #], you can do it like this:

=IF([Is this an Object]@row = "Yes", [Object #]@row, ([Box #]@row + "-" + [Folder #]@row))

So your results look like this:

Nic Larsen · 09/10/24