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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!