Forum Discussion
Microsoft List | Automatic Choice based on status of other columns
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 Con...
Rob_Elliottthank you! I am a total newbie so trying to teach myself. Right now I have AY25 Status set as a choice column.
Could you provide instructions on how I make my list dreams come true!?
JordanMcNutt create a new calculated column
and add the formula:
=IF(AND([Jen Confirms Commitment]="COMPLETE",[AY 25 Invoice Sent]="Complete",NOT(ISBLANK([AY Funds Received]))),"Complete","Waiting on payment")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
- THIS IS AMAZING! Thank you for your help! I have tried to populate this equation but I am not having luck getting it to work. It may be because of some updates I have made to my list. Is there a way I can share my list with you to help me get the formulate right?
