FVFO
New Member
Hi everyone,
I was needing your help on something, not really sure how to do it.
I have a document where on column B agents need to Input a date of denial, and column C a denial status that can be Denied or Appeal, on another column i have a formula that calculates time to refile and the available time to do this depends on what type of denial status was received.
Some agents are leaving column B (date of denial) empty but still filling out Denied or Appeal on Column C when this happens my formula doesnt calculate correctly.
How can I make sure that if they fill status on column C they get an alert prompting them to fill column B, would really prefer to avoid conditional formatting.
Can I get any input from you in regards to this scenario? Thanks in advance
Best wishes to all.
I was needing your help on something, not really sure how to do it.
I have a document where on column B agents need to Input a date of denial, and column C a denial status that can be Denied or Appeal, on another column i have a formula that calculates time to refile and the available time to do this depends on what type of denial status was received.
Some agents are leaving column B (date of denial) empty but still filling out Denied or Appeal on Column C when this happens my formula doesnt calculate correctly.
How can I make sure that if they fill status on column C they get an alert prompting them to fill column B, would really prefer to avoid conditional formatting.
Can I get any input from you in regards to this scenario? Thanks in advance
Best wishes to all.