MobileRead Forums - View Single Post - Composite Column based on Multiple Criteria

tamarissa · 11-12-2019, 12:15 AM

I'm looking to create a custom column based on information from 2 other columns. The end result I'm looking for is:

IF Column A (#keep_read) = "Yes" & Column B (#read_status) = "N",
THEN Column C (#send_kobo) = "Yes"
ELSE Column C (#send_kobo) = "No"

I can't figure out how to adapt any of the "If-then-else" formulas for multiple columns

. Or maybe there's a better option; as along as it works!

11-12-2019, 12:15 AM	#1
tamarissa Connoisseur Posts: 57 Karma: 10 Join Date: Aug 2018 Device: Kobo Aura H2O	Composite Column based on Multiple Criteria I'm looking to create a custom column based on information from 2 other columns. The end result I'm looking for is: IF Column A (#keep_read) = "Yes" & Column B (#read_status) = "N", THEN Column C (#send_kobo) = "Yes" ELSE Column C (#send_kobo) = "No" I can't figure out how to adapt any of the "If-then-else" formulas for multiple columns . Or maybe there's a better option; as along as it works!