Hi Team,
I am working on the data and i need to map the data with multiple criteria's, the data has multiple rows and some has Supplier ID and some hasn't, so the logic should be
if the supplier ID has numbers in it then look for the stakeholder and spend column if all 3 has values then result should be "Good"
if the supplier ID has number and stakeholder column has information but spend is '0' then 'Bad'
if the supplier ID has number and no stakeholder information and 0 spend then 'Very bad'
if supplier id has has number and no stakeholder information but has spend value then 'Better"
else Null
I have attached the excel file for the data example for your reference
Thank you!
Regards,
Dhruva
Solved! Go to Solution.
Happy to help : ) @SiddeshDhruva
Cheers and have a nice day!