Forum Discussion

Copper Contributor

Jun 28, 2024

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...

microsoft lists

Rob_Elliott

Bronze Contributor

Jun 28, 2024

JordanMcNutt yes this is quite straightforward providing column AY25 Status is a calculated column. If it isn't then you'd need to use a flow in Power Automate to set the value.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

JordanMcNutt
Copper Contributor
Jun 28, 2024
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!?
- Rob_Elliott
  Bronze Contributor
  Jun 29, 2024
  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)
  - JordanMcNutt
    Copper Contributor
    Jul 09, 2024
    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?