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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives