Hey all
I have a field on a custom form with 9 multiple choice answers. The formula only displays the value for 1 picked answer but obviously does not 'add' the total if more than 2 values are picked. Formula is as follows:
Solved! Go to Solution.
Views
Replies
Total Likes
Thanks, in the meantime I've worked out this as the solution:
I would recommend reviewing conversation around this idea:
https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/fix-order-of-items-in-selected-in-m...
@Doug_Den_Hoed__AtAppStore has made great suggestion, which I think could resolve your problem.
Thanks, in the meantime I've worked out this as the solution:
#aacgotcha01
Very nice @AndyKent: your "SUM(IF(CONTAINS(...)))" solution to add up multi-selected values is how I was going to suggest you solve it, too.
And @Rafal_Bainie, thanks for the tag; yesterday, I made some improvements to that how to sort multi-selected values technique, which I'll update under that related thread.
Regards,
Doug
I was going to answer with the same thing, @AndyKent. If(CONTAINS( is the way to go! I use this in a report of mine too.