Calculated Column Help

[Former Community Member]

Hello, I added this in text mode on a column in an issue report but it is not bringing up any results: displayname=Age Since Entry Date textmode=true valueexpression=IF(status='RLV', WEEKDAYDIFF({entryDate}, {actualCompletionDate}), WEEKDAYDIFF({entryDate}, $$TODAY)) valueformat=HTML Please help, thank you! Nadia Shakfeh IEHP

[TerryHy]

Try adding { } around status, as in: valueexpression=IF({status}='RLV', WEEKDAYDIFF({entryDate}, {actualCompletionDate}), WEEKDAYDIFF({entryDate}, $$TODAY)) That should do it. Terry Hynd EBSCO Information Services

[Former Community Member]

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