IF Statement Help

Lisa

Hello, everyone -

I'd really appreciate some help writing a conditional formula for a field entitled "Aging Type".

There are 4 valid values for the field -

Waiting on Approval

Waiting on RFx

Waiting on PO

Waiting on Payment

Waiting on COP

The values are based on seven columns -

ECM/IM Approved

RFx #

RFx Sub'd

PO #

COP Accepted

Billed in EBusiness

Received in Citi

It goes like this -

If Received in Citi is blank and Billed in EBusiness is not, then "Waiting on Payment"

If Billed in EBusiness is blank and COP Accepted is blank or N/A then "Waiting on COP"

If PO # is blank and RFx Sub'd is not, then "Waiting on PO"

If ECM/IM Approved is not blank and RFx # is blank then "Waiting on RFx"

If ECM/IM Approved is blank then "Waiting on Approval"

I filled in the values manually in the screenshot but I would like to have a formula that does it for me.

I would so appreciate the help with this. I'm not great with these types of formulas and it would take me too long to figure it out so I'd end up just continuing to fill this in manually every day.

Thanks in advance!

Lisa

 

 

 

Andrée Starå

Hi Lisa,

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Lisa

I thought I did on my first post, but here it is again just in case.

Mike Wilday

Are those dates being filled out in subsequent order? Would you ever have a date in Received in CIti and not have one in Billed in Ebusinees? 

If so, then you could this...

*Edit* I noticed an error after hitting POST

=IF(isblank([ECM/IM Approved]@row), "Waiting on Approval", IF(ISblank([RFx #]@row), "Waiting on RFx", IF(ISblank([RFx #]@row), "Waiting on RFx", IF(ISblank([PO #]@row), "Waiting on PO", IF(ISblank([COP Accepted]@row), "Waiting on COP", IF(ISblank([Billed in EBusiness]@row), "Waiting on Payment", ""))))))

Mike Wilday

I revised the last post slightly as I noticed an error after posting. 

Lisa

Thank you very much! I will give this a try!