I am developing an app to keep track of my mushroom hobby. Often times one can get more than one harvest out of the product. I am keeping the records in Google Docs and would like to have a total of 2 Columns/harvests displayed in a separate Column/Total Yield. I know I can do this within Google Docs with a simple formula but the formula would have to be carried down eventually hundreds of rows. Iโve tried different equations within App Sheet to accomplish this and none seem to work. I also added a Virtual Column thinking it could be done there. What equation would work and where Please?
LinkedIn
Twitter
