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!!
