Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function myFunction() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sheet1 = ss.getSheetByName("Character Sheet");
- var sheet2 = ss.getSheetByName("Marauder Abilities");
- var sheet3 = ss.getSheetByName("Warrior Abilities");
- var sheet4 = ss.getSheetByName("Dark Knight");
- var sheet5 = ss.getSheetByName("Gladiator");
- var sheet6 = ss.getSheetByName("Paladin");
- var sheet7 = ss.getSheetByName("Conjurer");
- var sheet8 = ss.getSheetByName("White Mage");
- var sheet9 = ss.getSheetByName("Arcanist");
- var sheet10 = ss.getSheetByName("Scholar");
- var sheet11 = ss.getSheetByName("Astrologian");
- var sheet12 = ss.getSheetByName("Pugilist");
- var sheet13 = ss.getSheetByName("Monk");
- var sheet14 = ss.getSheetByName("Lancer");
- var sheet15 = ss.getSheetByName("Dragoon");
- var sheet16 = ss.getSheetByName("Rogue");
- var sheet17 = ss.getSheetByName("Ninja");
- var sheet18 = ss.getSheetByName("Samurai");
- var sheet19 = ss.getSheetByName("Archer");
- var sheet20 = ss.getSheetByName("Bard");
- var sheet21 = ss.getSheetByName("Machinist");
- var sheet22 = ss.getSheetByName("Summoner");
- var sheet23 = ss.getSheetByName("Thaumaturge");
- var sheet24 = ss.getSheetByName("Black Mage");
- var sheet25 = ss.getSheetByName("Red Mage");
- var sheet26 = ss.getSheetByName("Garlean Pureblood");
- var cell1 = sheet1.getRange('B5');
- var cell2 = sheet1.getRange('C5');
- var cell3 = sheet1.getRange('D5');
- if (cell1.getValue() != "Marauder"||cell2.getValue() != "Marauder"||cell3.getValue() != "Marauder") {
- sheet2.hideSheet();
- }
- if (cell1.getValue() == "Marauder"||cell2.getValue() == "Marauder"||cell3.getValue() == "Marauder") {
- sheet2.showSheet();
- }
- if (cell1.getValue() != "Warrior"||cell2.getValue() != "Warrior"||cell3.getValue() != "Warrior") {
- sheet3.hideSheet();
- }
- if (cell1.getValue() == "Warrior"||cell2.getValue() == "Warrior"||cell3.getValue() == "Warrior") {
- sheet3.showSheet();
- }
- if (cell1.getValue() != "Dark Knight"||cell2.getValue() != "Dark Knight"||cell3.getValue() != "Dark Knight") {
- sheet4.hideSheet();
- }
- if (cell1.getValue() == "Dark Knight"||cell2.getValue() == "Dark Knight"||cell3.getValue() == "Dark Knight") {
- sheet4.showSheet();
- }
- if (cell1.getValue() != "Gladiator"||cell2.getValue() != "Gladiator"||cell3.getValue() != "Gladiator") {
- sheet5.hideSheet();
- }
- if (cell1.getValue() == "Gladiator"||cell2.getValue() == "Gladiator"||cell3.getValue() == "Gladiator") {
- sheet5.showSheet();
- }
- if (cell1.getValue() != "Paladin"||cell2.getValue() != "Paladin"||cell3.getValue() != "Paladin") {
- sheet6.hideSheet();
- }
- if (cell1.getValue() == "Paladin"||cell2.getValue() == "Paladin"||cell3.getValue() == "Paladin") {
- sheet6.showSheet();
- }
- if (cell1.getValue() != "Conjurer"||cell2.getValue() != "Conjurer"||cell3.getValue() != "Conjurer") {
- sheet7.hideSheet();
- }
- if (cell1.getValue() == "Conjurer"||cell2.getValue() == "Conjurer"||cell3.getValue() == "Conjurer") {
- sheet7.showSheet();
- }
- if (cell1.getValue() != "White Mage"||cell2.getValue() != "White Mage"||cell3.getValue() != "White Mage") {
- sheet8.hideSheet();
- }
- if (cell1.getValue() == "White Mage"||cell2.getValue() == "White Mage"||cell3.getValue() == "White Mage") {
- sheet8.showSheet();
- }
- if (cell1.getValue() != "Arcanist"||cell2.getValue() != "Arcanist"||cell3.getValue() != "Arcanist") {
- sheet9.hideSheet();
- }
- if (cell1.getValue() == "Arcanist"||cell2.getValue() == "Arcanist"||cell3.getValue() == "Arcanist") {
- sheet9.showSheet();
- }
- if (cell1.getValue() != "Scholar"||cell2.getValue() != "Scholar"||cell3.getValue() != "Scholar") {
- sheet10.hideSheet();
- }
- if (cell1.getValue() == "Scholar"||cell2.getValue() == "Scholar"||cell3.getValue() == "Scholar") {
- sheet10.showSheet();
- }
- if (cell1.getValue() != "Astrologian"||cell2.getValue() != "Astrologian"||cell3.getValue() != "Astrologian") {
- sheet11.hideSheet();
- }
- if (cell1.getValue() == "Astrologian"||cell2.getValue() == "Astrologian"||cell3.getValue() == "Astrologian") {
- sheet11.showSheet();
- }
- if (cell1.getValue() != "Pugilist"||cell2.getValue() != "Pugilist"||cell3.getValue() != "Pugilist") {
- sheet12.hideSheet();
- }
- if (cell1.getValue() == "Pugilist"||cell2.getValue() == "Pugilist"||cell3.getValue() == "Pugilist") {
- sheet12.showSheet();
- }
- if (cell1.getValue() != "Monk"||cell2.getValue() != "Monk"||cell3.getValue() != "Monk") {
- sheet13.hideSheet();
- }
- if (cell1.getValue() == "Monk"||cell2.getValue() == "Monk"||cell3.getValue() == "Monk") {
- sheet13.showSheet();
- }
- if (cell1.getValue() != "Lancer"||cell2.getValue() != "Lancer"||cell3.getValue() != "Lancer") {
- sheet14.hideSheet();
- }
- if (cell1.getValue() == "Lancer"||cell2.getValue() == "Lancer"||cell3.getValue() == "Lancer") {
- sheet14.showSheet();
- }
- if (cell1.getValue() != "Dragoon"||cell2.getValue() != "Dragoon"||cell3.getValue() != "Dragoon") {
- sheet15.hideSheet();
- }
- if (cell1.getValue() == "Dragoon"||cell2.getValue() == "Dragoon"||cell3.getValue() == "Dragoon") {
- sheet15.showSheet();
- }
- if (cell1.getValue() != "Rogue"||cell2.getValue() != "Rogue"||cell3.getValue() != "Rogue") {
- sheet16.hideSheet();
- }
- if (cell1.getValue() == "Rogue"||cell2.getValue() == "Rogue"||cell3.getValue() == "Rogue") {
- sheet16.showSheet();
- }
- if (cell1.getValue() != "Ninja"||cell2.getValue() != "Ninja"||cell3.getValue() != "Ninja") {
- sheet17.hideSheet();
- }
- if (cell1.getValue() == "Ninja"||cell2.getValue() == "Ninja"||cell3.getValue() == "Ninja") {
- sheet17.showSheet();
- }
- if (cell1.getValue() != "Samurai"||cell2.getValue() != "Samurai"||cell3.getValue() != "Samurai") {
- sheet18.hideSheet();
- }
- if (cell1.getValue() == "Samurai"||cell2.getValue() == "Samurai"||cell3.getValue() == "Samurai") {
- sheet18.showSheet();
- }
- if (cell1.getValue() != "Archer"||cell2.getValue() != "Archer"||cell3.getValue() != "Archer") {
- sheet19.hideSheet();
- }
- if (cell1.getValue() == "Archer"||cell2.getValue() == "Archer"||cell3.getValue() == "Archer") {
- sheet19.showSheet();
- }
- if (cell1.getValue() != "Bard"||cell2.getValue() != "Bard"||cell3.getValue() != "Bard") {
- sheet20.hideSheet();
- }
- if (cell1.getValue() == "Bard"||cell2.getValue() == "Bard"||cell3.getValue() == "Bard") {
- sheet20.showSheet();
- }
- if (cell1.getValue() != "Machinist"||cell2.getValue() != "Machinist"||cell3.getValue() != "Machinist") {
- sheet21.hideSheet();
- }
- if (cell1.getValue() == "Machinist"||cell2.getValue() == "Machinist"||cell3.getValue() == "Machinist") {
- sheet21.showSheet();
- }
- if (cell1.getValue() != "Summoner"||cell2.getValue() != "Summoner"||cell3.getValue() != "Summoner") {
- sheet22.hideSheet();
- }
- if (cell1.getValue() == "Summoner"||cell2.getValue() == "Summoner"||cell3.getValue() == "Summoner") {
- sheet22.showSheet();
- }
- if (cell1.getValue() != "Thaumaturge"||cell2.getValue() != "Thaumaturge"||cell3.getValue() != "Thaumaturge") {
- sheet23.hideSheet();
- }
- if (cell1.getValue() == "Thaumaturge"||cell2.getValue() == "Thaumaturge"||cell3.getValue() == "Thaumaturge") {
- sheet23.showSheet();
- }
- if (cell1.getValue() != "Black Mage"||cell2.getValue() != "Black Mage"||cell3.getValue() != "Black Mage") {
- sheet24.hideSheet();
- }
- if (cell1.getValue() == "Black Mage"||cell2.getValue() == "Black Mage"||cell3.getValue() == "Black Mage") {
- sheet24.showSheet();
- }
- if (cell1.getValue() != "Red Mage"||cell2.getValue() != "Red Mage"||cell3.getValue() != "Red Mage") {
- sheet25.hideSheet();
- }
- if (cell1.getValue() == "Red Mage"||cell2.getValue() == "Red Mage"||cell3.getValue() == "Red Mage") {
- sheet25.showSheet();
- }
- if (cell1.getValue() != "Garlean"||cell2.getValue() != "Garlean"||cell3.getValue() != "Garlean") {
- sheet26.hideSheet();
- }
- if (cell1.getValue() == "Garlean"||cell2.getValue() == "Garlean"||cell3.getValue() == "Garlean") {
- sheet26.showSheet();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement