Text Contain Formula

[Saraappsheet]

Can someone can help how to write this formuala in appsheet?

" =ArrayFormula( TEXTJOIN(" & ", TRUE, IF(REGEXMATCH(LOWER(A40), "urgent|important|routine|long-term"), "Time-dependent", ""), IF(REGEXMATCH(LOWER(A40), "meeting|presentation|report|email|follow-up|training|collaboration"), "Work-related", ""), IF(REGEXMATCH(LOWER(A40), "shopping|fitness|cooking|cleaning|leisure|family|finance"), "Personal", ""), IF(REGEXMATCH(LOWER(A40), "study|assignment|lecture|exam|group work|revision"), "Educational", ""), IF(REGEXMATCH(LOWER(A40), "workout|meditation|check-up|therapy|nutrition|rest"), "Health", ""), IF(REGEXMATCH(LOWER(A40), "project name|research|planning|execution|review|audit"), "Project-related", ""), IF(REGEXMATCH(LOWER(A40), "development|testing|debugging|deployment|code review|maintenance"), "Technical", "") ) ) "

[Marc_Dillon]

You should show examples of the data and the desired result.

[Saraappsheet]

"When I type the task it should show the category based on text contains"

Task Example	Category
Project update report	"Work-related"

[Marc_Dillon]

SELECT( Categories[Category] , CONTAINS( [_THISROW].[Task] , [keyword] ) )

[Saraappsheet]

I dont have a different category sheet. When I type the task description it should find the category according to the keyword straight as in the formula i wrote in gsheet

[Marc_Dillon]

I dont have a different category sheet

---

Then make one