I'm trying to set an if condition based on 2 fields being blank. (i.e. If Contract Date and Decline Reason are blank) I've tried nesting the And() and Isblank functions with no success. Can someone please post a sample of the If statement on how to do this?
Brian shared this idea · Jul 24, 2015
Comments
1 comment
Hi Brian,
This should work for you - just tested on my own app and works fine.
if(and(isblank({Contract Date}), isblank({Decline Reason})),"What You Want If True","What To Do If False")
Please sign in to leave a comment.