Forum Discussion
JonasHoffmann
Apr 22, 2022Copper Contributor
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