Forum Discussion

Hayleysea's avatar
Hayleysea
Resolver II
6 years ago
Solved

How to handle very complex IF statement

Hi there,   Here is my problem:   I have form that submits values into a table which is then used as my data source. This form has 50+ variables and not all of them will be filled in in any one s...
Need Help
Tips and Tricks
  • Hayleysea's avatar
    Hayleysea
    6 years ago

    Thanks v-easonf-msft  and amitchandak for your responses. 

     

    The way I have ended up doing it is to instead use if statements that look for blank values, and if it's blank then to show nothing (""), if theres a value then add it in. For example 

    Combinevalues(" ", If(isblank([v1]), "", "V1: " & [v1] & unichar(10) & unichar(10)),  If(isblank([v2]), "", "V2: " & [v2]& unichar(10) & unichar(10)) etc. )

     

    This is working to meet my needs, I just had to repeat it for each column in my calculated column

Hayleysea's avatar
Hayleysea
Resolver II
6 years ago

Thanks v-easonf-msft  and amitchandak for your responses. 

 

The way I have ended up doing it is to instead use if statements that look for blank values, and if it's blank then to show nothing (""), if theres a value then add it in. For example 

Combinevalues(" ", If(isblank([v1]), "", "V1: " & [v1] & unichar(10) & unichar(10)),  If(isblank([v2]), "", "V2: " & [v2]& unichar(10) & unichar(10)) etc. )

 

This is working to meet my needs, I just had to repeat it for each column in my calculated column