Formula: Multiple conditions to display "YES" or "NO"

Platform discussions Special workflows & use cases
,
1

Hi Community,

This may have already been answered before, but I wanted to see how I can design a formula where if and only if “EL Signed”, “941’s Rec’d”, and “ERC Calcs Rec’d” has a date inputted. Display “YES” in the Info Complete? Column and if there are no date in either one of these column display “NO.”

This is the current formula I am using, but it is incorrect as it displays “TRUE” or “FALSE”:

IF(AND({EL Signed} = “”, {941’s Rec’d} = “”, {ERC Calcs Rec’d} = “”, {Info Complete?}= “YES”, “NO”))

image
image869×799 59.2 KB

2

@sdesai

Try: IF(AND({EL Signed}, {941’s Rec’d}, {ERC Calcs Rec’d}), "YES", "NO")

Jim - The Monday Man
:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

1 Like
3

You are Awesome Jim, I have been watching your videos on Youtube and they have been very useful!
Thank you!
Shiv

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.