i am doing cross sheet reference and am getting #INVALID COLUMN VALUE error, I don't know why!

Saad

It only happens with this reference only

=INDEX({Start}, MATCH([Task Name]3, {Record}, 0))

if I change the value from {Start} to {client} it works and it gives me the value

Frank S.

Greetings @Saad,

Based on your explanation, the error is that the {Start} value is likely a date, and the column is not formatted as a date column. This would explain why the formula works when you change the value from {Start} to {client}, which is a text field.

If you change the column type to date and enter the formula, this should resolve your problem.

I hope this helps.