Stuart_Rice - profile

Stuart_Rice · Feb 17, 2020

Hi All: We are currently using the following formula to calculate course enrollment based on the values in an array. SUM(IF(VALUE(LEFT(ARRAYJOIN(Enrollment),FIND(’,’,ARRAYJOIN(Enrollment)),-1))=0,VALUE(Enrollment&’’),VALUE(LEFT(ARRAYJOIN(Enrollment),...

Stuart_Rice · Feb 17, 2020

Thanks! I’ve requested early access to it.

Stuart_Rice · Feb 17, 2020

Unfortunately, roll-ups won’t work because the field in question is a look-up field.

User Statistics

User Activity

Updating a formula to accommodate 4 or more items in an array

Re: Updating a formula to accommodate 4 or more items in an array

Re: Updating a formula to accommodate 4 or more items in an array