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

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
-
@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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!