search

gbrann / EVEProductionSuite

Eve Online - Production Suite is a set of Google and ESI tools to quickly and easily manage production, budget and basic corporate management with installing servers or adding any RL costs to your game play.
GNU General Public License v3.0
3 stars 0 forks source link

Template New Lines in all GESI pull tabs #21

Closed gbrann closed 6 years ago

gbrann commented 6 years ago

Would like the VLOOKUP Name functions to auto populate on new rows that are added by the ESI. This would fix an issue where some assets, prints, etc might not show up due to the lack of the name lookup formula.

Ref: https://productforums.google.com/forum/#!topic/docs/lZpA-egYvac

gbrann commented 6 years ago

@wytsa can you take a look at this and tell me what you think?

gbrann commented 6 years ago

@wytsa Any update?

wytsa commented 6 years ago

have input formulas to update the items in the column for 3 of the gesi tabs it should be fine for now to pull by name from assets/blueprints/jobs the market tab was giving me issues, i think the issue is from the first row being titles

gbrann commented 6 years ago

Formula changed to:

=arrayformula(if(row(I:I),vlookup(H:H,VLOOKUP!A:B,2,false),IF(ISBLANK(H:H),"",""))

gbrann commented 6 years ago

GESI-MARKET titles on Row 1 are manual, not ESI set. That row can be deleted.