Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
How can I implement an IF/AND/OR formula to calculate the desired output?
For example: if an item type=ROM Estimate AND accuracy>50% OR <-30% then YES, NO. OR if item type=Budget Estimate AND accuracy>30% or <15% then YES, NO OR item type=Definitive estimate AND accuracy >15% OR <-5% then YES, NO
Any help would be appreciated!