This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//GLOBALS: | |
//Choose which columns to hide in the Record Sheet for easier visualization of the resulting sheet | |
let colsToHide = [1, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19, 25, 26, 27, 28, 39, 40, 41, 42, 43, 44, 45]; | |
let newBidBackgroundColor = "#D8E271"; //Choose the background color of the adjusted bids. For getting the hex of other colors, visit: https://htmlcolorcodes.com/ | |
let newBidFormatting = "€##0.00" //Sets currency formatting to Bids | |
//Sets Custom Menu | |
function onOpen() { | |
var ui = SpreadsheetApp.getUi(); |