I have a formula check box whose value changes based on a date field (whether date is lesser than TODAY()
). Now i want to update a text field based on whether the check box is true or not. i created a workflow rule for this. it is working fine only when i manually change the date which then alters the check box and then the text is set . but the problem arises when i let the date expire , the formula check box value changes but the text field is not changed. it still holds the old value.
i was thinking of creating a formula text field and do some thing like a java if
if (check box == true)
{
text field = null;
}
but the i couldn't do it. It said the IF here only accepts true or false
Any inputs would be appreciated. ps. i know i have a check box as an added unnecessary layer when it should have been just based on the date field alone.