Hello @NilanjanDutta
that’s correct. Copy down/across won’t work for more than 1000 rows (or columns)
ypu have a few options (Assuming this is a one time thing)
- If you want to have the same “Comment” in each row, why not include it in the formula? if you want to keep the line item as an “Input” then you can then delete the formula from the line item; the data will remain.
- Section the data by using a filter that will divide the data to sections (less than 10000) and use the copy down with each filter.
- If you have the option available to you, create an excel where you can easily copy the desired data in as many rows that you want and import that file.
I’m actually interested to learn how other community members solve This limitation issue.
Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Dear community members
Consider posting your question as a new topic and not in the thread of another topic/question. This help other community members to easily find the answer they looking for and doesn't cause the original thread to be so cluttered that we can't find what we are looking for
