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

chrisfinlay
chrisfinlay ✭✭
edited 04/18/23 in Formulas and Functions

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"))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!