Forum Discussion

LauraJackson's avatar
LauraJackson
Copper Contributor
Jun 12, 2023

Formula assistance

Hi everyone, I am looking for assistance with creating a formula. I am still learning. Here is what I am looking to do:   If H2 equals 'Franchisor', and Q2 is blank, then populate Q2 from AQ2. If...
  • HansVogelaar's avatar
    Jun 12, 2023

    LauraJackson 

    In Q2:

     

    =IFS(H2="Franchisor", AQ2, H2="Ownership Company", AI2, H2="Management Company", AB2, TRUE, "")

Resources