Simple just make it so when hammer is reached it changes the cell that contains the formula that detects when the hammer is reached so it won't change the cell back if someone unvotesIn post 0, zoraster wrote:Major:
1. When the hammer is reached, the mod won't know about it if a vote is changed. The mod could go back and figure it out from the transcript, but this is designed to make life easier and be foolproof. Is there a google spreadsheet thing I can do to have a switch go if a certain value is reached that won't go back if the number goes down? In other words, I'd like Cell A1 (or whatever) to contain the # needed to lynch. IF Vote Total Cell is ever equal to or greater than A1, B1="Yes" EVEN IF Vote Total Cell is currently below A1.
i.e. in cell C6 put the formula that if any of cells B4:B34 becomes greater than the hammer number then delete the formula in c6 and change cell c6 to the word hammer, or even simpler just have it write the word hammer in cell c7 if any B4:B34 ever reaches the hammer number