Forum Discussion
sdhn
4 years agoResponsive Resident
Remove line from the code
Hi All, I have existing calculalted column code as below: Graphs = SWITCH( TRUE(), [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED" || [Vulnerable (Yes/No/Not Assessed)] = "UNKNOW...
- 4 years ago
Hi sdhn
Try this:
Graphs = SWITCH ( TRUE (), [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED", "NOT ASSESSED", [Vulnerable (Yes/No/Not Assessed)] = "YES" || [Vulnerable (Yes/No/Not Assessed)] = "NO", "ASSESSED" )or
Graphs = IF ( [Vulnerable (Yes/No/Not Assessed)] = "NOT ASSESSED", "NOT ASSESSED", "ASSESSED" )If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
sdhn
4 years agoResponsive Resident
Thanks