Solved: IF() statement not working

Sophtee · 05-23-2022 06:20 PM

Hey everyone

So I am creating a simple IF() statement but it isn't working:

When I enter "1" it is not showing "Continue". Can someone help me, please?

shahappsheet

Your Number column is Number type but in the IF statement you mentioned texttype ("1") and in this scenario no need [_THISROW]. Therefore, the code should be

IF(
[Number]=1,"continue","error"
)

View solution in original post

shahappsheet

Hi @Sophtee .

Your Number column is Number type but in the IF statement you mentioned texttype ("1") and in this scenario no need [_THISROW]. Therefore, the code should be

IF(
[Number]=1,"continue","error"
)