I was thrown off by "I track crew manually" being checked by default on the Import sheet, as it never was before, and imported with that checked. Now the Crew sheet won't listen to my Import sheet. Is there anything I can do to resume using the Import sheet that doesn't involve copying my Notes column by hand into a new sheet?
I was thrown off by "I track crew manually" being checked by default on the Import sheet, as it never was before, and imported with that checked. Now the Crew sheet won't listen to my Import sheet. Is there anything I can do to resume using the Import sheet that doesn't involve copying my Notes column by hand into a new sheet?
I was thrown off by "I track crew manually" being checked by default on the Import sheet, as it never was before, and imported with that checked. Now the Crew sheet won't listen to my Import sheet. Is there anything I can do to resume using the Import sheet that doesn't involve copying my Notes column by hand into a new sheet?
Sorry about that. I must've accidentally left it "on".
The manual upgrade only affects 3 columns so here's what I would do:
1. Make a new copy of the fresh Google Sheet (meaning make a fresh copy of the link on page 1 of this thread).
2. If you haven't sorted the crew tab on your *original* copy, copy Cols B, E and F from the new copy to your original copy. That should copy over all of the formulas that use the Import sheet.
3. If you *have* sorted the crew tab on your original copy, you could either sort it back and follow step 2, or maybe just take your "new" copy and do the upgrade again, and use that one instead.
If you run into any problems, feel free to DM me for more help.
@cmdrworf I unchecked that checkbox on the Dev copy so that'll be the default for future releases.
When I import from 6.48 to 6.51 in the crew tab, row 1046 is blank, when I use the import tab.
I believe that is Marayana. I forgot to copy her into the crew tab. I've got her fixed in 6.52. if you want to fix 6.51 BEFORE SORTING the crew tab highlight the row above and drag the little square on the far right to copy the entire row above to that row. that will pull all the formulas down and fix her.
Comments
I knew there would still be something...... dang it.
tagging @mr_sparky on this one.
Sorry about that. I must've accidentally left it "on".
The manual upgrade only affects 3 columns so here's what I would do:
1. Make a new copy of the fresh Google Sheet (meaning make a fresh copy of the link on page 1 of this thread).
2. If you haven't sorted the crew tab on your *original* copy, copy Cols B, E and F from the new copy to your original copy. That should copy over all of the formulas that use the Import sheet.
3. If you *have* sorted the crew tab on your original copy, you could either sort it back and follow step 2, or maybe just take your "new" copy and do the upgrade again, and use that one instead.
If you run into any problems, feel free to DM me for more help.
@cmdrworf I unchecked that checkbox on the Dev copy so that'll be the default for future releases.
Exception: Range not found
Tagging @mr_sparky
I believe that is Marayana. I forgot to copy her into the crew tab. I've got her fixed in 6.52. if you want to fix 6.51 BEFORE SORTING the crew tab highlight the row above and drag the little square on the far right to copy the entire row above to that row. that will pull all the formulas down and fix her.