Hi!
Thank you in advance for any advice you can provide. I'm trying to design a flow. Ideally, when an opportunity record is updated, the flow would look at the related account record. On the account record, there are grades K-12. Each relevant grade field will have the total number of students. Depending on the opportunity, some of the grade level fields may not be filled in. For example, if the opportunity is a K-5 school, then the 6-12 grade level fields on the account record won't be filled in.
Ideally, the flow would pull the grade level fields if the field is filled in, calculate the average, and add the average to the opportunity record.
Any idea how to design this flow?
#Flows #Automation #Formulas #Help #Flow