Character (and team) requirement query - baerrach/msf-googlesheet-tools GitHub Wiki

Raids often have requirements before nodes can be attempted.

To check whether your alliance is ready to try those raids you will need to create a new sheet.

In cell A1 enter the character name, in cell 2 enter the query.

For example this query will show Gear Tear and ISO levels for Northstar:

Northstar
=QUERY(Roster!A:W, "select A, G, N, O, P, Q, R where B='" & A31 & "'")

Header Name	Header Column
Name	A
Gear Tier	G
Striker	N
Fortifier	O
Healer	P
Raider	Q

To add additional characters you can put the additional character names in row 1 in the columns after the query has completed. In this example; H, O, V, AC

You'll need to add some way to check whether these characters are ready.

Some options are

• update the query to hard code the requirement. The downside to this is you can't see how your alliance is progressing towards this goal.

• add additional columns after the query that will return true/false for the requirements, use conditional formatting to highlight matching lines.