The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Jan 28, 2020 12:13 PM
I’m sure it’s here or obvious, but I’m not sure what to search for. I simply want a formula that says:
If Field A is not empty, then 1 else 2.
Sorry if it’s obvious.
Thanks.
Solved! Go to Solution.
Jan 28, 2020 01:19 PM
Jan 28, 2020 01:19 PM
IF(A!=BLANK(),1,2)
or IF(A=BLANK(),2,1)
it’s the same thing.
Jan 28, 2020 03:38 PM
Great suggestions @Moe! Another route you can take is:
IF({Field A}, 1, 2)