I have a field called "Will Not See" where a provider marks why they may not be seeing a patient on their rounding list for the day. I have subsequent fields, [Follow Up], and [No Follow Up Reason], and i would like to automatically set those values depending on the current value of [Will Not See].
I tried this in the Auto Compute section of [Follow Up]
IF(
[Will Not See]="CMO/Hospice",
AND("No Follow Up",[No Follow Up Reason]="CMO/Hospice"),
[Follow Up])
and this seems fine logically to me (could be wrong) but its failing because its expecting a yes/no condition.
If i remove the AND statement, it at least passes validation, but i want to set the value of two columns and not just one ๐ค
IF(
[Will Not See]="CMO/Hospice",
"No Follow Up",
[Follow Up])
what am i doing wrong here?
LinkedIn
Twitter
