Forum Discussion
Solved
MS LIST : Formula based on two columns
Hi 🙂 I was wondering if someone could help me out with a calculated column. I would like a column to display ''A'' or ''B'' based on two other columns (''M3'' and ''M4'') if those are blanks. For t...
AudreySC use this: =IF(AND(ISBLANK([M3]),ISBLANK([M4])), "A", "B")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
AudreySC use this: =IF(AND(ISBLANK([M3]),ISBLANK([M4])), "A", "B")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)
Amazing thank you !!!