IF Calculation on Column

[Former Community Member]

Hello, I have entered this into a column on a task report but it's not working: displayname=Age Since Entry Date textmode=true valueexpression=IF(status='CPL', WEEKDAYDIFF(actualStartDate, actualCompletionDate), (WEEKDAYDIFF(actualStartDate, $$NOW)) valueformat=HTML Would appreciate any help or advice. Thank you. Nadia Shakfeh IEHP

[Heather_Kulbacki]

I would try this for the valueexpression valueexpression=IF(status='CPL',WEEKDAYDIFF(actualStartDate,actualCompletionDate),WEEKDAYDIFF(actualStartDate,$$NOW)) You had 4 left parens, but only 3 right parens. I don't think you need the left paren before the 2nd WEEKDAYDIFF

[Former Community Member]

Thank you. Unfortunately it still isn't producing any results. Nadia Shakfeh IEHP

[JustinRe]

Hi Nadia, The only thing missing are brackets around your fields. displayname=Age Since Entry Date textmode=true valueexpression=IF({status}="CPL", WEEKDAYDIFF({actualStartDate}, {actualCompletionDate}), WEEKDAYDIFF({actualStartDate}, $$NOW)) valueformat=HTML Justin Renteria SSFCU

[Former Community Member]

It worked! Thank you so much, Justin :) Nadia Shakfeh IEHP