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

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


Answers

  • Frank S.
    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.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎