Filter and update the new column with data

Question

Hello,

I am currently doing below step like filtering out each criteria and updating the text/comment in new column. Is there any easy way to do it in one go ?

Step : Filter in Merge cell (eg. Filter for "Income" and update the new column with " Verified". then Filter for "Expense" and update the same new column with "Sent out").

AMansour · Accepted Answer

hello @Lakshraj

I'll use one formula avec

IF 
Contains([Merged column], 'interest recevable') 
THEN 'Interest recevable' 
ELSEif Contains([Merged column], 'interest payable')
THEN 'Interest Payable'
Elseif Contains([Merged column], 'FEES AND COMMS PYBL')
THEN 'Fees and Commissions Payable'
Else ''
Endif

let me know if that what you are looking for.

cheers

Amr