I wanted to return 1 for all the records closed between Monday to Friday
Return 0 for any other stages ( in progress, needs analysis ...)
i'm using below formula , its throwing syntax error
IF( StageName = "Closed Won",
"IF(
AND(
NOT(ISBLANK(CloseDate)),
TEXT( DAY(CloseDate) ) <> "1",
TEXT( DAY(CloseDate) ) <> "7"
),
1,
0
)","0")
What is that I'm doing incorrect ?
1 respuesta
Hello@Saikamal Paradi,
Please try,
IF(
AND(
TEXT(StageName) = "Closed Won",
NOT(ISBLANK(CloseDate)),
TEXT( DAY(CloseDate) ) <> 1,
TEXT( DAY(CloseDate) ) <> 7)
) ,1,0
)
