Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Conditional formula for multiple criteria

SiddeshDhruva
7 - Meteor

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

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @SiddeshDhruva 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644001689854.png

 

Hope this helps : )

 

SiddeshDhruva
7 - Meteor

Thanks a ton @atcodedog05 , it worked exactly how i wanted..

 

Regards,

Siddesh Dhruva

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @SiddeshDhruva 

Cheers and have a nice day!

Labels