I have faced an issue while trying to add multiple conditions inside IF is not working
=NP("Formula","=IF(AND([@[Job Task No.]]=1,[@[Job No.]]=""TIME AWAY""),1,0)")
If I have only one condition if works. But when put AND with multiple conditions is not working.
Thanks in Advance.