Invalid Value error using INDEX & MATCH


I copied a project PMO and reset the links from project metadata to the project input sheet for the new set. All the columns now return "INVALID VALUE". I changed some headings which match on both sheets, the formula shown was not changed.

Any help would be appreciated.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!