Formula Help

Amber N

Hello

I am looking for assistance with a formula. What I need is '# of days for COC Completion' to equal 'Date COC was Finalized' - 'Date COC Determined' with a cavoite that if 'Was PCT hospitalized within 14 days of COC' = Yes, than instead of 'Date COC Determine' it needs to go off 'Date D/C from Hospital'

Is that possible?

Dan Beres

Hi @Amber N,

If I am understanding this correctly something like this should work:
=IF([Was PCT Hospitalized within 14 days of COC?]@row = "Yes", [Date COC was Finalized]@row - [Date D/C from Hospital]@row, [Date COC was Finalized]@row - [Date COC Determined]@row)

This statement will check if that PCT Hospitalized within 14 days of COC is Yes, and if it is it will go off of Date discharged from hospital. Otherwise, if it is not Yes it will default to the COC Finalized - COC Determined.

Let me know if you run into any issues with this!

Dan Beres

Hi @Amber N,

If I am understanding this correctly something like this should work:
=IF([Was PCT Hospitalized within 14 days of COC?]@row = "Yes", [Date COC was Finalized]@row - [Date D/C from Hospital]@row, [Date COC was Finalized]@row - [Date COC Determined]@row)

This statement will check if that PCT Hospitalized within 14 days of COC is Yes, and if it is it will go off of Date discharged from hospital. Otherwise, if it is not Yes it will default to the COC Finalized - COC Determined.

Let me know if you run into any issues with this!

Amber N

Thank you so much, that is what I needed!