ISCRITICAL

KarineMul22_TPg

Has anybody in Smartsheet EU successfully used ISCRITICAL on a gantt please - we have been trying, and every single time it's coming with the error "Incorrect argument". The formula is simple enough =IF(ISCRITICAL([Task Name]@row),1,0)

Thank you

Gia Thinh

Can you provide a screenshot?

KarineMul22_TPg

Sure, here it is:

Gia Thinh

2 things need to be fixed:

1- Your formula is not correct. Change it to : =IF(ISCRITICAL([Task Name]@row),1,0)

2- Change the property of the Critical Path (y/N) column from Text/Number to Checkbox in order to match with the boolean result of the formula

KarineMul22_TPg

Hi, Thanks but it is the same formula, and I have also tried the flag or checkbox, and it's the same issue

KarineMul22_TPg

Apology, I can see the difference now! Needed my glasses, thank you!

Gia Thinh

I am happy to help.