Convert text to a value formula creation help request.
We have a sports pool that I get submissions from 3 dozen people weekly. He with the most points a weekend close wins. Right now I need to go through and manually check each person’s submission after the weekend is over, and tally them up. I make mistakes sometimes, and they get pointed out (think pitchforks coming).
Is there a formula method that allows, me to do the following?
If I create a column of controls, the correct picks, to compare text in the submissions to set correct answers to fill green, and incorrect to fill red? Also is there a way in a hidden column, to generate a 1 or 0 value, so that the correct cells can be summed for a tally under each submission for each individual?
BlueD2O1 karma
Convert text to a value formula creation help request. We have a sports pool that I get submissions from 3 dozen people weekly. He with the most points a weekend close wins. Right now I need to go through and manually check each person’s submission after the weekend is over, and tally them up. I make mistakes sometimes, and they get pointed out (think pitchforks coming).
Is there a formula method that allows, me to do the following? If I create a column of controls, the correct picks, to compare text in the submissions to set correct answers to fill green, and incorrect to fill red? Also is there a way in a hidden column, to generate a 1 or 0 value, so that the correct cells can be summed for a tally under each submission for each individual?
View HistoryShare Link