Hi all,
I am working with two Smartsheet sheets:
- Projects Intake & control Sheet
- Project Status / Status Update Sheet
The goal is to use the Intake Sheet as the source/master sheet and automatically pull values into the Status Update Sheet based on a matching Project ID.
For example, in the Status Update Sheet I want to pull fields such as:
- Project
- Platform
- Project ID
- QDOC number
- Project planning link
- WorkApp link
I am using Project ID as the unique key.
The formula works correctly when I paste it into a single row/cell. For example:
=INDEX({1. Projects Intake Sheet - Internal CLD pr Range 1}; MATCH([Project ID]@row; {1. Projects Intake Sheet - Internal CLD pr Range 2}; 0))
I also tested a simpler formula:
=COUNTIF({Intake Project ID}; [Project ID]@row)
When I paste this formula into one cell, it correctly returns 1, so the Project ID match seems to work.
However, when I convert the same formula to a Column Formula, the cells return either:
#INVALID REF
or sometimes:
#NO MATCH or black (which means it doesnt recognize the project ID
The issue only appears after using Convert to Column Formula.
Has anyone seen this behavior before, where a cross-sheet formula works in an individual cell but fails as a column formula ? We use Smartsheet control center to also update these fields from the intake sheet in the summary sheet.
Any suggestions on how to troubleshoot or resolve this would be very welcome.
Thank you!
Best regards,
