Formula Help


I have two helper columns that I want to use to complete the first column.

The "Find a TAX ID" column is used to see if the row tax id is on another sheet. If so, it brings in the tax id.

The Find a Complete is looking at the other sheet, finding the tax ID and seeing if it's marked complete. If it is complete, it's returning a "1".

If I get a Tax ID # in the first column, plus a "1" in the second column, I want to mark "Network Change Request (Y or N) as a "Y"

I need help with the formula for the first column.

Thank you for any help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!