Define message "High Risk" Or "Low Risk" , When the job is at risk

[phornsophon]

Hi, community,

The appsheet able to Define message “High Risk” Or “Low Risk” Then the column Type = “Human” and column Level = “High” and column Potential Risk = “High” , and save the into column Assessment level = " High Risk " OR column Type = “Environment” and column Level = “Medium” and column Potential Risk = “Medium” , and save the into column Assessment level = " Low Risk "
Is there a formula?
Thank you

[Marc_Dillon]

help.appsheet.com

IFS()

First-match conditional evaluation

help.appsheet.com

IF()

Either/or conditional evaluation

help.appsheet.com

AND()

Are all true?

[phornsophon]

I’m really grateful for your help.

[Aurelien]

In addition to what @Marc_Dillon said:

help.appsheet.com

SWITCH()

Chose-one conditional evaluation

[phornsophon]

I’m really grateful for your help.