Dear Appsheet Masters,
I am creating a simple cash-out app for servers, bartenders and promoters at our rest./bar/club entertainment center.
Some big cash-out (total tip of a master bill) will be shared by several people. I want to maker sure the total of the percentages they put it under one cash-out code equals 100%. The entries of the same cash-out share the same cash-out code.
In excel, it is very easy to do. I have a “% Check” column and the formula is “=IF(SUMIF(C:C,C2,G:G)<>100%,”% Split Wrong (Split Toatl Should be 100%)","% Split Correct")". However, in appsheet I don’t not how to select a specific cell in a appsheet formula like I select “C2” in the Excel formula above.
The excel sheet format is shown below: