Hi all, me again.. I am encountering a new formula issue

chrisfinlay

I am creating a risks and issues log and am attempting to replicate of another risk and issues log from excel we have. My issue is that it will not upload correctly as the excel files has two sheets and Smartsheet doesn't have the capability for me to have two tabs in one sheet. I have attempted to begin with a simple automated calculation of the two fields however it is not working.

This is my current formula, I wish to extend this to cover all eventualities however would like to get the start off it working. Any help would be greatly appreciated.

=IF(AND(OR(Consequence4 = "Insignificant", Likelihood4 = "Unlikely", [Inherent Risk Rating]4 = "Low")))

similar but included brackets and took out OR but also inserted the general @row

=IF(AND([Consequence]@row = "Insignificant", [Likelihood]@row = "Unlikely" = "Low"))

Dale Murphy

@chrisfinlay Checkout the syntax of an IF statement:

https://help.smartsheet.com/function/if?frame=0&nav=1

=IF(AND([Consequence]@row = "Insignificant", [Likelihood]@row = "Unlikely"), "Low") should be close ...

dm