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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!