Forum Discussion

JonasHoffmann's avatar
JonasHoffmann
Copper Contributor
Apr 22, 2022

Multiple IFs in SharePoint Calculated Field (Need one for specific date to output "Contacted")

Hello.

 

I can't seem to find the correct code for:

=IF(ISBLANK(DateofContact),"Not Contacted",Today-DateofContact)

 

The above code works, but I need to add another IF to do the following:

IF the date in (DateofContact) field is equals 1/1/2022, then output "Already Contacted"

Like: IF(DateofContact)=DATE(1/1/2022), "Already Contacted"


Can you help me?

No RepliesBe the first to reply