Hopefully I can explain this clearly.

I am tracking the status of payment for ‘sponsors’. Here are my column headers:

Partners

AY25 Payment Status

AY25 Status

AY25 Level

AY25 Giving

Jen Confirms Commitment

CR Entered

AY25 Invoice Sent

CR Invoice

AY25 Funds Received

Proposal Added by DO

Proposal Funded DO

Invoice Responsibility

AY25 Invoice Link

I column “AY25 Status” to change colors or to choose a pre-populated choice automatically when data is added into the other columns. 

For example if:

Jen Confirms Commitment = COMPLETE

AY25 Invoice Sent = COMPLETE

but AY25 Funds Received is blank I want column AY25 Status to say “waiting on payment”.

There are a handful of status choices I want to auto populate during the process. Is this possible?

​Hopefully I can explain this clearly. I am tracking the status of payment for ‘sponsors’. Here are my column headers:PartnersAY25 Payment StatusAY25 StatusAY25 LevelAY25 GivingJen Confirms CommitmentCR EnteredAY25 Invoice SentCR InvoiceAY25 Funds ReceivedProposal Added by DOProposal Funded DOInvoice ResponsibilityAY25 Invoice Link I column “AY25 Status” to change colors or to choose a pre-populated choice automatically when data is added into the other columns.  For example if:Jen Confirms Commitment = COMPLETEAY25 Invoice Sent = COMPLETEbut AY25 Funds Received is blank I want column AY25 Status to say “waiting on payment”.There are a handful of status choices I want to auto populate during the process. Is this possible?   Read More

​