Best Of

To make it easier try breaking your IF function into the 3 separate parts/functions it should have, to write those out logically, and then combine into the final formula by putting commas between them. If, Then, Else/otherwise:

If Assigned date is blank: ISBLANK([Assigned Date]@row)

Then calculate networkdays between created date and today: NETWORKDAYS([Created Date]@row, TODAY())

Else/otherwise calculate networkdays between created date and assigned date: NETWORKDAYS([Created Date]@row, [Assigned Date]@row)

Put them all together to get: =IF(ISBLANK([Assigned Date]@row), NETWORKDAYS([Created Date]@row, TODAY()),

NETWORKDAYS([Created Date]@row, [Assigned Date]@row))

Here's the IF function page if it's helpful to read through:

IF Function | Smartsheet Learning Center

So you are getting the circular reference because you are evaluating the cell that you put the formula in. But I don't think the Match formula is going to do what you want it to do.It just returns a numerical value of the location of a cell in a table.

I think the formula you need to use is probably just a vlookup, but for that to work you have to have a unique project ID or something to help it find the project name from the other sheet. How are you identifying the project names?

@Christina09 What @Adam Costello suggested would be the most accurate since you can do an exact match.

Otherwise you can make it work with Contains, but it's possible you may get erroneous matches if your item numbers get longer and contain the shorter number.

Formula:

=JOIN(COLLECT({Item Sheet | Item Name}, {Item Sheet | Item Number}, CONTAINS(@cell, [List of Item Numbers SemiColons]@row)), CHAR(10))

Screenshot:

@Michelle Choate 2 Thanks for the tag