I have several single select columns with "yes/no" selection answers. I want to make a sort of if/than formula to combine the information from those yes/no columns. For example, in the photo below, there are columns a, b, c ,d, e. We will call those ...
I have 5 non-value fields that indicate if a person has paid an application fee or not. The fields are: 180 GBP, 210 GBP, 240 GBP, 270 GBP, and 300 GBP. If a person has paid, it will say "Completed" under the column that they have paid. It will say "...
Wow this is incredibly useful. I do have very limited experience with script, so when I initially tried to run this script with the real table info plugged in, it wouldn't run and kept giving me "SyntaxError: Unexpected string" so I have attached ano...
I have been messing around with nested formulas for about an hour and it warms my heart knowing that what I had recently written was actually close to the formula you provided above (Which worked perfectly). Thank you so much! Working with someone el...
