Help

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.

Formula Help: Isblank equivalent needed

5538 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Al_Ansar_FC
5 - Automation Enthusiast
5 - Automation Enthusiast

Since the Formula column displays zeros for empty cells, I need isBlank or isNotBlank formula to make my formula work.

My {Results} column needs to return a value of “Draw” if {Home goals} = {Away goals} and the {Points} column will display a value of “1” if {Result} = “Draw”. However, since a 0-0 tie is a possibility I can’t exclude zero values. Now My table displays Draw and 1 point for all upcoming matches.
Can anyone help please!
Thanks,
Anna

2 Replies 2
Katherine_Harkn
6 - Interface Innovator
6 - Interface Innovator

It’s not clear from your question exactly what you’re doing. But you can make a blank field into a zero using IF:
if({home goals}="", 0, {home goals})

Actually i wanted the opposite, blanks not to show zeros, so the “” worked. Thx @Katherine_Harkness