Adding different number of years depending on Classification Level/Status
I keep track of my suppliers based on if they are on my Approved Supplier List (ASL) and if they are on the ASL they are assigned different levels. The periodic review date for suppliers on the ASL is based on the Level they are assigned.
Level 1 (Level 1 - Conditional), yearly
Level 2 (Level 2 - Conditional), every two years
Level 3 (Level 3 - Conditional), every three years
I also have Suppliers categorized as "Not on ASL", "Inactive" and "Disapproved"
I'd like to put together a formula to automatically calculate the Periodic Review Due date based on the Classification Level/Status explained above and also return an "N/A" if the Classification Level/ Status are any of these "Not on ASL", "Inactive" and "Disapproved"
I'm speculating that some sort of IFTHEN formula would need to be used but am having trouble wrapping my mind around the exact way to make the formula. Any help would be greatly appreciated. Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!