Challenge5

[Pushpendra_kowthavarapu]

Hi, can someone help me, how to write the expression in (If condition). We need to write like whether that cell consists of specific string or not. Below is the image reference.

[Shiva_Nikhil]

@Pushpendra_kowthavarapu

currentrow(7).tostring.tolower.contains(“completed”)

7 is the column index

[Pushpendra_kowthavarapu]

If we have to write doesn’t contains, how to write that.

[Shiva_Nikhil]

@Pushpendra_kowthavarapu

you can use not at starting for doesn’t contains

not CurrentRow(7).ToString.ToLower.Contains(“completed”)