Timeline for INDEX-formula throws random #REF!-errors due to [illogical] column value out of range
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 1, 2019 at 14:21 | comment | added | FrancescoLS | I am having exactly the same problem but I did not understand the workaround you proposed: if the latency problem is there, it will be there even if it's done on another sheet, right? At least, this is happening for me :\ Any suggestion? | |
| Apr 13, 2017 at 12:57 | history | edited | CommunityBot |
replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/
|
|
| Jan 12, 2016 at 13:03 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |
added 123 characters in body
|
| Jan 12, 2016 at 12:39 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |
Update due to reviewing of the demo spreadsheet.
|
| Jan 12, 2016 at 12:27 | comment | added | Rubén - Volunteer Moderator -♦ | @HenrikSöderlund The dates were considered ambiguous because the OP have shared only a screenshot and we could not be sure if the horizontal alignment was customized :) | |
| Jan 12, 2016 at 4:19 | comment | added | Henrik Söderlund | The date column has a proper date format applied, it is not ambiguous. See demo link in comment above. | |
| Jan 10, 2016 at 18:46 | comment | added | user79865 | That's possible. I upvoted your comment about giving us a demo spreadsheet... | |
| Jan 10, 2016 at 18:45 | comment | added | Rubén - Volunteer Moderator -♦ | @Normal: what if the horizontal alignment was customized? | |
| Jan 10, 2016 at 18:39 | comment | added | user79865 | On the other hand, the Date column on the screenshot is right-aligned, indicating it's indeed recognized as a date (not a string). In this case there can be no ambiguity: the displayed format is just for human consumption, internally the date is the number of days since Day 0. | |
| Jan 10, 2016 at 17:41 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |
added 159 characters in body
|
| Jan 10, 2016 at 17:30 | history | answered | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |