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
Answers
-
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. 😎
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives