<HELP!> How to populate a field automatically when it matches keyword

[elstar]

Hi all!

I'm trying run some workflow to pick up keywords from a specific column and if the cell contains the required keywords, then it will indicate in the relevant column with something like a "Yes" but to no avail.. wondering if any one can kindly help me?

Table to begin with:

Group ID	Group Name	Group Tasks	Scrub	Clean/ Wash/ Mop	Dry
1	A	clear trash, scrub, off the lights
2	B	clean fans, dry fans
3	C	hang dry clothes
4	D	wipe tables
5	E	mop the canteen
6	F	coordinate

I'm trying to achieve the below with the highlighted fields autopopulated

Group ID	Group Name	Group Tasks	Scrub	Clean/ Wash/ Mop	Dry
1	A	clear trash, scrub, off the lights	Yes
2	B	clean fans, dry fans		Yes	Yes
3	C	hang dry clothes			Yes
4	D	wipe tables
5	E	mop the canteen		Yes
6	F	coordinate

Any help/advice please? thanks a million!!

[FilipR · Accepted solution]

Try the Formula tool:

The LowerCase is just there so that the formula will work even if someone uses capital letters in the Group Tasks (will work with "dry" or "Dry" or "DRY').

[binuacs · Accepted solution]

@elstar One way of doing this

[SPetrie · Accepted solution]

Alternative way of doing it.

[elstar]

thank you all! i've tried these and work!