pattern-repetition-formula-creating tool

group

Count

f for copy

formula

pattern

for column info

共同作業 powered by Smartsheet | 不正使用/迷惑行為の報告

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 9)), CONTAINS(INDEX({Multi-Select Dropdown List}, 9), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 10)), CONTAINS(INDEX({Multi-Select Dropdown List}, 10), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 10)), CONTAINS(INDEX({Multi-Select Dropdown List}, 10), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 11)), CONTAINS(INDEX({Multi-Select Dropdown List}, 11), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 11)), CONTAINS(INDEX({Multi-Select Dropdown List}, 11), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 12)), CONTAINS(INDEX({Multi-Select Dropdown List}, 12), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 12)), CONTAINS(INDEX({Multi-Select Dropdown List}, 12), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 13)), CONTAINS(INDEX({Multi-Select Dropdown List}, 13), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 13)), CONTAINS(INDEX({Multi-Select Dropdown List}, 13), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 14)), CONTAINS(INDEX({Multi-Select Dropdown List}, 14), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 14)), CONTAINS(INDEX({Multi-Select Dropdown List}, 14), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 15)), CONTAINS(INDEX({Multi-Select Dropdown List}, 15), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 15)), CONTAINS(INDEX({Multi-Select Dropdown List}, 15), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 16)), CONTAINS(INDEX({Multi-Select Dropdown List}, 16), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 16)), CONTAINS(INDEX({Multi-Select Dropdown List}, 16), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 17)), CONTAINS(INDEX({Multi-Select Dropdown List}, 17), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 17)), CONTAINS(INDEX({Multi-Select Dropdown List}, 17), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 18)), CONTAINS(INDEX({Multi-Select Dropdown List}, 18), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 18)), CONTAINS(INDEX({Multi-Select Dropdown List}, 18), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 19)), CONTAINS(INDEX({Multi-Select Dropdown List}, 19), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 19)), CONTAINS(INDEX({Multi-Select Dropdown List}, 19), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 20)), CONTAINS(INDEX({Multi-Select Dropdown List}, 20), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 20)), CONTAINS(INDEX({Multi-Select Dropdown List}, 20), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 21)), CONTAINS(INDEX({Multi-Select Dropdown List}, 21), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 21)), CONTAINS(INDEX({Multi-Select Dropdown List}, 21), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 22)), CONTAINS(INDEX({Multi-Select Dropdown List}, 22), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 22)), CONTAINS(INDEX({Multi-Select Dropdown List}, 22), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 23)), CONTAINS(INDEX({Multi-Select Dropdown List}, 23), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 23)), CONTAINS(INDEX({Multi-Select Dropdown List}, 23), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 24)), CONTAINS(INDEX({Multi-Select Dropdown List}, 24), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 24)), CONTAINS(INDEX({Multi-Select Dropdown List}, 24), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 25)), CONTAINS(INDEX({Multi-Select Dropdown List}, 25), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 25)), CONTAINS(INDEX({Multi-Select Dropdown List}, 25), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 26)), CONTAINS(INDEX({Multi-Select Dropdown List}, 26), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 26)), CONTAINS(INDEX({Multi-Select Dropdown List}, 26), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 27)), CONTAINS(INDEX({Multi-Select Dropdown List}, 27), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 27)), CONTAINS(INDEX({Multi-Select Dropdown List}, 27), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 28)), CONTAINS(INDEX({Multi-Select Dropdown List}, 28), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 28)), CONTAINS(INDEX({Multi-Select Dropdown List}, 28), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 29)), CONTAINS(INDEX({Multi-Select Dropdown List}, 29), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 29)), CONTAINS(INDEX({Multi-Select Dropdown List}, 29), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 30)), CONTAINS(INDEX({Multi-Select Dropdown List}, 30), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 30)), CONTAINS(INDEX({Multi-Select Dropdown List}, 30), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 31)), CONTAINS(INDEX({Multi-Select Dropdown List}, 31), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 31)), CONTAINS(INDEX({Multi-Select Dropdown List}, 31), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 32)), CONTAINS(INDEX({Multi-Select Dropdown List}, 32), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 32)), CONTAINS(INDEX({Multi-Select Dropdown List}, 32), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 33)), CONTAINS(INDEX({Multi-Select Dropdown List}, 33), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 33)), CONTAINS(INDEX({Multi-Select Dropdown List}, 33), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 34)), CONTAINS(INDEX({Multi-Select Dropdown List}, 34), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 34)), CONTAINS(INDEX({Multi-Select Dropdown List}, 34), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 35)), CONTAINS(INDEX({Multi-Select Dropdown List}, 35), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 35)), CONTAINS(INDEX({Multi-Select Dropdown List}, 35), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 36)), CONTAINS(INDEX({Multi-Select Dropdown List}, 36), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 36)), CONTAINS(INDEX({Multi-Select Dropdown List}, 36), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 37)), CONTAINS(INDEX({Multi-Select Dropdown List}, 37), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 37)), CONTAINS(INDEX({Multi-Select Dropdown List}, 37), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 38)), CONTAINS(INDEX({Multi-Select Dropdown List}, 38), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 38)), CONTAINS(INDEX({Multi-Select Dropdown List}, 38), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 39)), CONTAINS(INDEX({Multi-Select Dropdown List}, 39), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 39)), CONTAINS(INDEX({Multi-Select Dropdown List}, 39), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 40)), CONTAINS(INDEX({Multi-Select Dropdown List}, 40), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 40)), CONTAINS(INDEX({Multi-Select Dropdown List}, 40), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 41)), CONTAINS(INDEX({Multi-Select Dropdown List}, 41), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 41)), CONTAINS(INDEX({Multi-Select Dropdown List}, 41), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 42)), CONTAINS(INDEX({Multi-Select Dropdown List}, 42), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 42)), CONTAINS(INDEX({Multi-Select Dropdown List}, 42), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 43)), CONTAINS(INDEX({Multi-Select Dropdown List}, 43), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 43)), CONTAINS(INDEX({Multi-Select Dropdown List}, 43), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 44)), CONTAINS(INDEX({Multi-Select Dropdown List}, 44), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 44)), CONTAINS(INDEX({Multi-Select Dropdown List}, 44), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 45)), CONTAINS(INDEX({Multi-Select Dropdown List}, 45), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 45)), CONTAINS(INDEX({Multi-Select Dropdown List}, 45), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 46)), CONTAINS(INDEX({Multi-Select Dropdown List}, 46), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 46)), CONTAINS(INDEX({Multi-Select Dropdown List}, 46), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 47)), CONTAINS(INDEX({Multi-Select Dropdown List}, 47), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 47)), CONTAINS(INDEX({Multi-Select Dropdown List}, 47), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 48)), CONTAINS(INDEX({Multi-Select Dropdown List}, 48), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 48)), CONTAINS(INDEX({Multi-Select Dropdown List}, 48), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 49)), CONTAINS(INDEX({Multi-Select Dropdown List}, 49), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 49)), CONTAINS(INDEX({Multi-Select Dropdown List}, 49), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 50)), CONTAINS(INDEX({Multi-Select Dropdown List}, 50), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 50)), CONTAINS(INDEX({Multi-Select Dropdown List}, 50), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 51)), CONTAINS(INDEX({Multi-Select Dropdown List}, 51), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 51)), CONTAINS(INDEX({Multi-Select Dropdown List}, 51), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 52)), CONTAINS(INDEX({Multi-Select Dropdown List}, 52), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 52)), CONTAINS(INDEX({Multi-Select Dropdown List}, 52), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 53)), CONTAINS(INDEX({Multi-Select Dropdown List}, 53), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 53)), CONTAINS(INDEX({Multi-Select Dropdown List}, 53), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 54)), CONTAINS(INDEX({Multi-Select Dropdown List}, 54), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 54)), CONTAINS(INDEX({Multi-Select Dropdown List}, 54), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 55)), CONTAINS(INDEX({Multi-Select Dropdown List}, 55), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 55)), CONTAINS(INDEX({Multi-Select Dropdown List}, 55), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 56)), CONTAINS(INDEX({Multi-Select Dropdown List}, 56), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 56)), CONTAINS(INDEX({Multi-Select Dropdown List}, 56), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 57)), CONTAINS(INDEX({Multi-Select Dropdown List}, 57), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 57)), CONTAINS(INDEX({Multi-Select Dropdown List}, 57), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 58)), CONTAINS(INDEX({Multi-Select Dropdown List}, 58), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 58)), CONTAINS(INDEX({Multi-Select Dropdown List}, 58), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 59)), CONTAINS(INDEX({Multi-Select Dropdown List}, 59), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 59)), CONTAINS(INDEX({Multi-Select Dropdown List}, 59), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 60)), CONTAINS(INDEX({Multi-Select Dropdown List}, 60), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 60)), CONTAINS(INDEX({Multi-Select Dropdown List}, 60), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 61)), CONTAINS(INDEX({Multi-Select Dropdown List}, 61), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 61)), CONTAINS(INDEX({Multi-Select Dropdown List}, 61), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 62)), CONTAINS(INDEX({Multi-Select Dropdown List}, 62), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 62)), CONTAINS(INDEX({Multi-Select Dropdown List}, 62), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 63)), CONTAINS(INDEX({Multi-Select Dropdown List}, 63), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 63)), CONTAINS(INDEX({Multi-Select Dropdown List}, 63), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 64)), CONTAINS(INDEX({Multi-Select Dropdown List}, 64), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 64)), CONTAINS(INDEX({Multi-Select Dropdown List}, 64), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 65)), CONTAINS(INDEX({Multi-Select Dropdown List}, 65), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 65)), CONTAINS(INDEX({Multi-Select Dropdown List}, 65), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 66)), CONTAINS(INDEX({Multi-Select Dropdown List}, 66), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 66)), CONTAINS(INDEX({Multi-Select Dropdown List}, 66), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 67)), CONTAINS(INDEX({Multi-Select Dropdown List}, 67), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 67)), CONTAINS(INDEX({Multi-Select Dropdown List}, 67), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 68)), CONTAINS(INDEX({Multi-Select Dropdown List}, 68), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 68)), CONTAINS(INDEX({Multi-Select Dropdown List}, 68), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 69)), CONTAINS(INDEX({Multi-Select Dropdown List}, 69), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 69)), CONTAINS(INDEX({Multi-Select Dropdown List}, 69), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 70)), CONTAINS(INDEX({Multi-Select Dropdown List}, 70), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 70)), CONTAINS(INDEX({Multi-Select Dropdown List}, 70), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 71)), CONTAINS(INDEX({Multi-Select Dropdown List}, 71), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 71)), CONTAINS(INDEX({Multi-Select Dropdown List}, 71), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 72)), CONTAINS(INDEX({Multi-Select Dropdown List}, 72), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 72)), CONTAINS(INDEX({Multi-Select Dropdown List}, 72), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 73)), CONTAINS(INDEX({Multi-Select Dropdown List}, 73), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 73)), CONTAINS(INDEX({Multi-Select Dropdown List}, 73), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 74)), CONTAINS(INDEX({Multi-Select Dropdown List}, 74), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 74)), CONTAINS(INDEX({Multi-Select Dropdown List}, 74), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 75)), CONTAINS(INDEX({Multi-Select Dropdown List}, 75), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 75)), CONTAINS(INDEX({Multi-Select Dropdown List}, 75), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 76)), CONTAINS(INDEX({Multi-Select Dropdown List}, 76), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 76)), CONTAINS(INDEX({Multi-Select Dropdown List}, 76), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 77)), CONTAINS(INDEX({Multi-Select Dropdown List}, 77), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 77)), CONTAINS(INDEX({Multi-Select Dropdown List}, 77), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 78)), CONTAINS(INDEX({Multi-Select Dropdown List}, 78), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 78)), CONTAINS(INDEX({Multi-Select Dropdown List}, 78), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 79)), CONTAINS(INDEX({Multi-Select Dropdown List}, 79), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 79)), CONTAINS(INDEX({Multi-Select Dropdown List}, 79), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 80)), CONTAINS(INDEX({Multi-Select Dropdown List}, 80), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 80)), CONTAINS(INDEX({Multi-Select Dropdown List}, 80), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 81)), CONTAINS(INDEX({Multi-Select Dropdown List}, 81), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 81)), CONTAINS(INDEX({Multi-Select Dropdown List}, 81), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 82)), CONTAINS(INDEX({Multi-Select Dropdown List}, 82), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 82)), CONTAINS(INDEX({Multi-Select Dropdown List}, 82), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 83)), CONTAINS(INDEX({Multi-Select Dropdown List}, 83), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 83)), CONTAINS(INDEX({Multi-Select Dropdown List}, 83), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 84)), CONTAINS(INDEX({Multi-Select Dropdown List}, 84), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 84)), CONTAINS(INDEX({Multi-Select Dropdown List}, 84), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 85)), CONTAINS(INDEX({Multi-Select Dropdown List}, 85), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 85)), CONTAINS(INDEX({Multi-Select Dropdown List}, 85), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 86)), CONTAINS(INDEX({Multi-Select Dropdown List}, 86), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 86)), CONTAINS(INDEX({Multi-Select Dropdown List}, 86), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 87)), CONTAINS(INDEX({Multi-Select Dropdown List}, 87), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 87)), CONTAINS(INDEX({Multi-Select Dropdown List}, 87), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 88)), CONTAINS(INDEX({Multi-Select Dropdown List}, 88), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 88)), CONTAINS(INDEX({Multi-Select Dropdown List}, 88), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 89)), CONTAINS(INDEX({Multi-Select Dropdown List}, 89), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 89)), CONTAINS(INDEX({Multi-Select Dropdown List}, 89), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 90)), CONTAINS(INDEX({Multi-Select Dropdown List}, 90), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 90)), CONTAINS(INDEX({Multi-Select Dropdown List}, 90), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 91)), CONTAINS(INDEX({Multi-Select Dropdown List}, 91), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 91)), CONTAINS(INDEX({Multi-Select Dropdown List}, 91), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 92)), CONTAINS(INDEX({Multi-Select Dropdown List}, 92), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 92)), CONTAINS(INDEX({Multi-Select Dropdown List}, 92), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 93)), CONTAINS(INDEX({Multi-Select Dropdown List}, 93), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 93)), CONTAINS(INDEX({Multi-Select Dropdown List}, 93), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 94)), CONTAINS(INDEX({Multi-Select Dropdown List}, 94), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 94)), CONTAINS(INDEX({Multi-Select Dropdown List}, 94), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 95)), CONTAINS(INDEX({Multi-Select Dropdown List}, 95), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 95)), CONTAINS(INDEX({Multi-Select Dropdown List}, 95), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 96)), CONTAINS(INDEX({Multi-Select Dropdown List}, 96), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 96)), CONTAINS(INDEX({Multi-Select Dropdown List}, 96), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 97)), CONTAINS(INDEX({Multi-Select Dropdown List}, 97), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 97)), CONTAINS(INDEX({Multi-Select Dropdown List}, 97), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 98)), CONTAINS(INDEX({Multi-Select Dropdown List}, 98), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 98)), CONTAINS(INDEX({Multi-Select Dropdown List}, 98), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 99)), CONTAINS(INDEX({Multi-Select Dropdown List}, 99), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 99)), CONTAINS(INDEX({Multi-Select Dropdown List}, 99), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 100)), CONTAINS(INDEX({Multi-Select Dropdown List}, 100), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 100)), CONTAINS(INDEX({Multi-Select Dropdown List}, 100), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

100

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 101)), CONTAINS(INDEX({Multi-Select Dropdown List}, 101), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 101)), CONTAINS(INDEX({Multi-Select Dropdown List}, 101), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

101

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 102)), CONTAINS(INDEX({Multi-Select Dropdown List}, 102), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 102)), CONTAINS(INDEX({Multi-Select Dropdown List}, 102), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

102

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 103)), CONTAINS(INDEX({Multi-Select Dropdown List}, 103), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 103)), CONTAINS(INDEX({Multi-Select Dropdown List}, 103), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

103

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 104)), CONTAINS(INDEX({Multi-Select Dropdown List}, 104), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 104)), CONTAINS(INDEX({Multi-Select Dropdown List}, 104), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

104

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 105)), CONTAINS(INDEX({Multi-Select Dropdown List}, 105), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 105)), CONTAINS(INDEX({Multi-Select Dropdown List}, 105), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

105

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 106)), CONTAINS(INDEX({Multi-Select Dropdown List}, 106), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 106)), CONTAINS(INDEX({Multi-Select Dropdown List}, 106), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

106

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 107)), CONTAINS(INDEX({Multi-Select Dropdown List}, 107), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 107)), CONTAINS(INDEX({Multi-Select Dropdown List}, 107), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

107

100

=IFERROR(MID([Prep List]@row, FIND([DL2]#, SUBSTITUTE([Prep List]@row, [DL1]#, [DL2]#, 1)) + 1, FIND([DL2]#, SUBSTITUTE([Prep List]@row, [DL1]#, [DL2]#, 2)) - FIND([DL2]#, SUBSTITUTE([Prep List]@row, [DL1]#, [DL2]#, 1)) - 1), "")

[DL2]#, 2

[DL2]#, 1

120

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 1)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 1)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 1)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 1)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 1)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 1)), 1, 0), 0)

List}, 1

121

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 2)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 2)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 2)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 2)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 2)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 2)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 2)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 2)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 2)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 2)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 2)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 2)), 1, 0), 0)

List}, 2

122

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 3)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 3)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 3)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 3)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 3)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 3)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 3)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 3)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 3)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 3)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 3)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 3)), 1, 0), 0)

List}, 3

123

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 4)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 4)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 4)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 4)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 4)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 4)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 4)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 4)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 4)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 4)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 4)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 4)), 1, 0), 0)

List}, 4

124

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 5)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 5)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 5)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 5)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 5)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 5)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 5)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 5)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 5)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 5)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 5)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 5)), 1, 0), 0)

List}, 5

125

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 6)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 6)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 6)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 6)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 6)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 6)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 6)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 6)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 6)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 6)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 6)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 6)), 1, 0), 0)

List}, 6

126

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 7)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 7)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 7)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 7)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 7)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 7)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 7)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 7)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 7)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 7)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 7)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 7)), 1, 0), 0)

List}, 7

127

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 8)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 8)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 8)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 8)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 8)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 8)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 8)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 8)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 8)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 8)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 8)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 8)), 1, 0), 0)

List}, 8

128

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 9)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 9)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 9)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 9)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 9)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 9)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 9)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 9)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 9)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 9)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 9)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 9)), 1, 0), 0)

List}, 9

129

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 10)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 10)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 10)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 10)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 10)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 10)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 10)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 10)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 10)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 10)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 10)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 10)), 1, 0), 0)

List}, 10

130

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 11)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 11)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 11)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 11)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 11)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 11)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 11)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 11)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 11)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 11)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 11)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 11)), 1, 0), 0)

List}, 11

131

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 12)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 12)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 12)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 12)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 12)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 12)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 12)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 12)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 12)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 12)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 12)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 12)), 1, 0), 0)

List}, 12

132

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 13)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 13)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 13)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 13)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 13)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 13)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 13)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 13)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 13)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 13)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 13)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 13)), 1, 0), 0)

List}, 13

133

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 14)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 14)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 14)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 14)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 14)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 14)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 14)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 14)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 14)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 14)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 14)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 14)), 1, 0), 0)

List}, 14

134

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 15)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 15)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 15)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 15)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 15)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 15)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 15)), IF(HAS(CompletedA@row, INDEX({Multiple list : List}, 15)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 15)), IF(HAS(CompletedB@row, INDEX({Multiple list : List}, 15)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : List}, 15)), IF(HAS(CompletedC@row, INDEX({Multiple list : List}, 15)), 1, 0), 0)

List}, 15

135

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 17)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 17)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 17)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 17)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 17)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 17)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 17)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 17)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 17)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 17)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 17)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 17)), 1, 0), 0)

Name}, 17

136

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 18)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 18)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 18)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 18)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 18)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 18)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 18)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 18)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 18)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 18)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 18)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 18)), 1, 0), 0)

Name}, 18

137

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 19)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 19)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 19)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 19)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 19)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 19)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 19)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 19)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 19)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 19)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 19)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 19)), 1, 0), 0)

Name}, 19

138

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 20)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 20)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 20)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 20)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 20)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 20)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 20)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 20)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 20)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 20)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 20)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 20)), 1, 0), 0)

Name}, 20

139

'=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 21)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 21)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 21)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 21)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 21)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 21)), 1, 0), 0)

=IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 21)), IF(HAS(CompletedA@row, INDEX({Multiple list : Name}, 21)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 21)), IF(HAS(CompletedB@row, INDEX({Multiple list : Name}, 21)), 1, 0), 0) + IF(HAS([Not Complete]@row, INDEX({Multiple list : Name}, 21)), IF(HAS(CompletedC@row, INDEX({Multiple list : Name}, 21)), 1, 0), 0)

Name}, 21

140

=IF(ISBLANK([R1]@row), "", INDEX(Start:Start, VALUE([R1]@row)))

144

=IF(ISBLANK([R1]@row), "", INDEX(End:End, VALUE([R1]@row)))

149

=IF(COUNT(ANCESTORS()) > 0, AND(Start@row <= PARENT(Start@row) + 0, End@row >= PARENT(Start@row) + 0, End@row <= PARENT(End@row)))

+ 0

182

183

=IF(ISDATE([D1]@row), IF(ISDATE([S1]@row), IF(AND([S1]@row <= [D1]@row, [E1]@row >= [D1]@row), 1, 0), 0) + IF(ISDATE([S2]@row), IF(AND([S2]@row <= [D1]@row, [E2]@row >= [D1]@row), 1, 0), 0) + IF(ISDATE([S3]@row), IF(AND([S3]@row <= [D1]@row, [E3]@row >= [D1]@row), 1, 0), 0) + IF(ISDATE([S4]@row), IF(AND([S4]@row <= [D1]@row, [E4]@row >= [D1]@row), 1, 0), 0))

[D1

203

=COUNTIFS([Start Date]:[Start Date], <=[D10]@row, [End Date]:[End Date], >=[D10]@row, [Assigned To]:[Assigned To], [Assigned To]@row)

D10

214

=IF([D2]@row + 1 <= [End Date]@row, [D2]@row + 1)

@cell)), 2

222

=IFERROR(SUBSTITUTE([D-1]@row, [D2]@row, ""), "")

-1

231

232

=IF(NOT(CONTAINS(CHAR(10), [D-1]@row)), [D-1]@row, MID([D-1]@row, 1, FIND(CHAR(10), [D-1]@row)))

-1

242

=IF(AND([Start Date]@row <= TODAY(1), TODAY(1) <= [End Date]@row), 1)

248

249

250

251

=IF([Is Parent]@row, INDEX({Sheet B: Attendance_Register : Date}, 1) + "", IF(ISBLANK([Employee ID]@row), "", IF(HAS({us-federal-holidays : date}, INDEX({Sheet B: Attendance_Register : Date}, 1)), "Holiday", IF(OR(WEEKDAY(INDEX({Sheet B: Attendance_Register : Date}, 1)) = 1, WEEKDAY(INDEX({Sheet B: Attendance_Register : Date}, 1)) = 7), "Weekend", IF(COUNTIFS(INDEX({Sheet B: Attendance_Register : Leave Checked}, 0, [Employee ID Index]@row), 1, {Sheet B: Attendance_Register : Date}, INDEX({Sheet B: Attendance_Register : Date}, 1)) > 0, "On Leave", IF(CONTAINS("Complete", JOIN(COLLECT({Sheet C : Timesheet : Entry Status}, {Sheet C : Timesheet : Employee ID}, [Employee ID]@row, {Sheet C : Timesheet Range : Date}, INDEX({Sheet B: Attendance_Register : Date}, 1)))), "Complete", "Pending"))))))

Date}, 1

282

=IF([Row ID]@row = 1, 0, IF(INDEX([Qual1]:[Qual1], [Row ID]@row - 1) > [Qual1]@row, 0, INDEX([Qual1]:[Qual1], [Row ID]@row - 1)))

Qual1

292

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 1)), CONTAINS(INDEX({Multi-Select Dropdown List}, 1), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

293

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 2)), CONTAINS(INDEX({Multi-Select Dropdown List}, 2), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 2)), CONTAINS(INDEX({Multi-Select Dropdown List}, 2), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

294

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 3)), CONTAINS(INDEX({Multi-Select Dropdown List}, 3), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 3)), CONTAINS(INDEX({Multi-Select Dropdown List}, 3), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

295

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 4)), CONTAINS(INDEX({Multi-Select Dropdown List}, 4), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 4)), CONTAINS(INDEX({Multi-Select Dropdown List}, 4), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

296

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 5)), CONTAINS(INDEX({Multi-Select Dropdown List}, 5), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 5)), CONTAINS(INDEX({Multi-Select Dropdown List}, 5), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

297

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 6)), CONTAINS(INDEX({Multi-Select Dropdown List}, 6), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 6)), CONTAINS(INDEX({Multi-Select Dropdown List}, 6), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

298

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 7)), CONTAINS(INDEX({Multi-Select Dropdown List}, 7), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 7)), CONTAINS(INDEX({Multi-Select Dropdown List}, 7), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

299

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 8)), CONTAINS(INDEX({Multi-Select Dropdown List}, 8), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 8)), CONTAINS(INDEX({Multi-Select Dropdown List}, 8), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

300

'=IF(HAS([Keywords (Multi-Select Dropdown)]@row, INDEX({Multi-Select Dropdown List}, 9)), CONTAINS(INDEX({Multi-Select Dropdown List}, 9), INDEX({Search Text: Text}, MATCH(ID@row, {Search Text: ID}, 0))))

301

302

=MOD(SUMIFS(INDEX({Group Qualification Assignment Range 1:10}, 0, 1), {Group Qualification Assignment Range : Row ID}, <=[Row ID]@row), INDEX({Number of Qualified and Required: Qualified}, 1))

312

=IF([Count M]@row > 4, SUBSTITUTE([List-4]@row, [Opt5]@row, ""))

> 4

List-4

Opt5

328

=IF(COUNTM@row > 3, SUBSTITUTE([TC-2]@row, [TC3]@row, ""))

> 3

[TC-2

TC3

335

=IF(COUNTM@row > 3, SUBSTITUTE([TC-2]@row, [TC3]@row, ""))

TC2

([TC -1

341

342

=IF(COUNTM@row > 3, LEFT([Access-2]@row, FIND(CHAR(10), [Access-2]@row)), [AC2]@row)

Access-2

345

346

347

348

=SUBSTITUTE([Access-1]@row, [AC2]@row, "")

Access-1

AC2

354

355

=IF([Distinct Assigned]@row >= 2, CHAR(10) + CHAR(10) + UPPER(INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 2)) + ":" + CHAR(10) + JOIN(COLLECT(CHILDREN([Resource Summary]@row), CHILDREN([Assigned To]@row), INDEX(DISTINCT(CHILDREN([Assigned To]@row)), 2)), CHAR(10)))

>= 2

@row)), 2

374

375

376

=IFERROR(IF(ISTEXT([L4]@row), LEFT(SUBSTITUTE(List¬@row, JOIN([L1]@row:[L4]@row, DLM#) + DLM#, ""), FIND(DLM#, SUBSTITUTE(List¬@row, JOIN([L1]@row:[L4]@row, DLM#) + DLM#, "")) - 1)), "")

393

394

=IFERROR(MID(List@row, [c10]@row, [c11]@row - [c10]@row), "")

[c10

[c11

414

=IFERROR(INDEX(SUCCESSORS([Task Name]@row), 1, 3), "")

422

=IFERROR(IF(AND(COUNTIFS(COLLECT([Row No]:[Row No], [Pred 3]:[Pred 3], 1), CONTAINS(@cell, JOIN(SUCCESSORS([Task Name]@row), ", "))) > 0, [is Before]@row), 1), "")

Pred 3

430

431

432

433

434

435

436

=IF([FilterType3]@row = "Country", Country@row, IF([FilterType3]@row = "Department", Department@row, IF([FilterType3]@row = "Ethnisity", Ethnicity@row, IF([FilterType3]@row = "Business Unit", [Business Unit]@row, IF([FilterType3]@row = "Job Title", [Job Title]@row)))))

FilterType3

439

'=IF([FilterType1]@row = "Country", Country@row, IF([FilterType1]@row = "Department", Department@row, IF([FilterType1]@row = "Ethnisity", Ethnicity@row, IF([FilterType1]@row = "Business Unit", [Business Unit]@row, IF([FilterType1]@row = "Job Title", [Job Title]@row)))))

FilterType1

442

=SUM(

'=SUM(IF(HAS([Recurrence Day Names (weekly)]@row, "Monday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Monday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Tuesday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Tuesday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Wednesday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Wednesday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Thursday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Thursday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Friday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Friday"), {month_name}, HAS(@cell, [Month_]@row)), 0)

=SUM(IF(HAS([Recurrence Day Names (weekly)]@row, "Monday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Monday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Tuesday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Tuesday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Wednesday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Wednesday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Thursday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Thursday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+IF(HAS([Recurrence Day Names (weekly)]@row, "Friday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Friday"), {month_name}, HAS(@cell, [Month_]@row)), 0)

IF(HAS([Recurrence Day Names (weekly)]@row, "Monday"), COUNTIFS({day_of_week_name}, HAS(@cell, "Monday"), {month_name}, HAS(@cell, [Month_]@row)), 0)+

Monday

448

=AVERAGE(

'=AVERAGE(IF(HAS([Day of Week Selection]@row, "Mon"), COUNTIFS({Day of Week}, HAS(@cell, "Mon"), {month number}, HAS(@cell, Month@row))+IF(HAS([Day of Week Selection]@row, "Tue"), COUNTIFS({Day of Week}, HAS(@cell, "Tue"), {month number}, HAS(@cell, Tueth@row))+IF(HAS([Day of Week Selection]@row, "Wed"), COUNTIFS({Day of Week}, HAS(@cell, "Wed"), {month number}, HAS(@cell, Wedth@row))+IF(HAS([Day of Week Selection]@row, "Thu"), COUNTIFS({Day of Week}, HAS(@cell, "Thu"), {month number}, HAS(@cell, Thuth@row))+IF(HAS([Day of Week Selection]@row, "Fri"), COUNTIFS({Day of Week}, HAS(@cell, "Fri"), {month number}, HAS(@cell, Frith@row))

=AVERAGE(IF(HAS([Day of Week Selection]@row, "Mon"), COUNTIFS({Day of Week}, HAS(@cell, "Mon"), {month number}, HAS(@cell, Month@row))+IF(HAS([Day of Week Selection]@row, "Tue"), COUNTIFS({Day of Week}, HAS(@cell, "Tue"), {month number}, HAS(@cell, Tueth@row))+IF(HAS([Day of Week Selection]@row, "Wed"), COUNTIFS({Day of Week}, HAS(@cell, "Wed"), {month number}, HAS(@cell, Wedth@row))+IF(HAS([Day of Week Selection]@row, "Thu"), COUNTIFS({Day of Week}, HAS(@cell, "Thu"), {month number}, HAS(@cell, Thuth@row))+IF(HAS([Day of Week Selection]@row, "Fri"), COUNTIFS({Day of Week}, HAS(@cell, "Fri"), {month number}, HAS(@cell, Frith@row))

IF(HAS([Day of Week Selection]@row, "Mon"), COUNTIFS({Day of Week}, HAS(@cell, "Mon"), {month number}, HAS(@cell, Month@row))+

Mon

454

=IF([m#]@row > value1, FIND(CHAR(10), [Multiple Email List]@row, [cvalue2]@row + 1))

value1

value2

474

=IF([m#]@row > 3, FIND(CHAR(10), make@row, [c2]@row + 1), 0)

492

=IF([m#]@row >value1, MID(make@row, [value2]@row + 1, [value3]@row - [value2]@row), IF([m#]@row =value1, MID(make@row, [value2]@row + 1, LEN(make@row) - [value2]@row + 1)))

value1

value2

value3

513

'=IF(INDEX(DISTINCT(make:make), 1) = make@row, RIGHT("0"+1,2) ,IF(INDEX(DISTINCT(make:make), 2) = make@row, RIGHT("0"+2,2) ,IF(INDEX(DISTINCT(make:make), 3) = make@row, RIGHT("0"+3,2) ,IF(INDEX(DISTINCT(make:make), 4) = make@row, RIGHT("0"+4,2) ,IF(INDEX(DISTINCT(make:make), 5) = make@row, RIGHT("0"+5,2) ,IF(INDEX(DISTINCT(make:make), 6) = make@row, RIGHT("0"+6,2) ,IF(INDEX(DISTINCT(make:make), 7) = make@row, RIGHT("0"+7,2) ,IF(INDEX(DISTINCT(make:make), 8) = make@row, RIGHT("0"+8,2) ,IF(INDEX(DISTINCT(make:make), 9) = make@row, RIGHT("0"+9,2) ,IF(INDEX(DISTINCT(make:make), 10) = make@row, RIGHT("0"+10,2) ,IF(INDEX(DISTINCT(make:make), 11) = make@row, RIGHT("0"+11,2) ,IF(INDEX(DISTINCT(make:make), 12) = make@row, RIGHT("0"+12,2) ,IF(INDEX(DISTINCT(make:make), 13) = make@row, RIGHT("0"+13,2) ,IF(INDEX(DISTINCT(make:make), 14) = make@row, RIGHT("0"+14,2) ,IF(INDEX(DISTINCT(make:make), 15) = make@row, RIGHT("0"+15,2) ,IF(INDEX(DISTINCT(make:make), 16) = make@row, RIGHT("0"+16,2) ,IF(INDEX(DISTINCT(make:make), 17) = make@row, RIGHT("0"+17,2) ,IF(INDEX(DISTINCT(make:make), 18) = make@row, RIGHT("0"+18,2) ,IF(INDEX(DISTINCT(make:make), 19) = make@row, RIGHT("0"+19,2) ,IF(INDEX(DISTINCT(make:make), 20) = make@row, RIGHT("0"+20,2) ,IF(INDEX(DISTINCT(make:make), 21) = make@row, RIGHT("0"+21,2) ,IF(INDEX(DISTINCT(make:make), 22) = make@row, RIGHT("0"+22,2) ,IF(INDEX(DISTINCT(make:make), 23) = make@row, RIGHT("0"+23,2) ,IF(INDEX(DISTINCT(make:make), 24) = make@row, RIGHT("0"+24,2) ,IF(INDEX(DISTINCT(make:make), 25) = make@row, RIGHT("0"+25,2) ,IF(INDEX(DISTINCT(make:make), 26) = make@row, RIGHT("0"+26,2) ,IF(INDEX(DISTINCT(make:make), 27) = make@row, RIGHT("0"+27,2) ,IF(INDEX(DISTINCT(make:make), 28) = make@row, RIGHT("0"+28,2) ,IF(INDEX(DISTINCT(make:make), 29) = make@row, RIGHT("0"+29,2) ,IF(INDEX(DISTINCT(make:make), 30) = make@row, RIGHT("0"+30,2) ,IF(INDEX(DISTINCT(make:make), 31) = make@row, RIGHT("0"+31,2) ,IF(INDEX(DISTINCT(make:make), 32) = make@row, RIGHT("0"+32,2) ,IF(INDEX(DISTINCT(make:make), 33) = make@row, RIGHT("0"+33,2) ,IF(INDEX(DISTINCT(make:make), 34) = make@row, RIGHT("0"+34,2) ,IF(INDEX(DISTINCT(make:make), 35) = make@row, RIGHT("0"+35,2) ,IF(INDEX(DISTINCT(make:make), 36) = make@row, RIGHT("0"+36,2) ,IF(INDEX(DISTINCT(make:make), 37) = make@row, RIGHT("0"+37,2) ,IF(INDEX(DISTINCT(make:make), 38) = make@row, RIGHT("0"+38,2) ,IF(INDEX(DISTINCT(make:make), 39) = make@row, RIGHT("0"+39,2) ,IF(INDEX(DISTINCT(make:make), 40) = make@row, RIGHT("0"+40,2) ,IF(INDEX(DISTINCT(make:make), 41) = make@row, RIGHT("0"+41,2) ,IF(INDEX(DISTINCT(make:make), 42) = make@row, RIGHT("0"+42,2) ,IF(INDEX(DISTINCT(make:make), 43) = make@row, RIGHT("0"+43,2) ,IF(INDEX(DISTINCT(make:make), 44) = make@row, RIGHT("0"+44,2) ,IF(INDEX(DISTINCT(make:make), 45) = make@row, RIGHT("0"+45,2) ,IF(INDEX(DISTINCT(make:make), 46) = make@row, RIGHT("0"+46,2) ,IF(INDEX(DISTINCT(make:make), 47) = make@row, RIGHT("0"+47,2) ,IF(INDEX(DISTINCT(make:make), 48) = make@row, RIGHT("0"+48,2) ,IF(INDEX(DISTINCT(make:make), 49) = make@row, RIGHT("0"+49,2) ,IF(INDEX(DISTINCT(make:make), 50) = make@row, RIGHT("0"+50,2)

=IF(INDEX(DISTINCT(make:make), 1) = make@row, RIGHT("0"+1,2) ,IF(INDEX(DISTINCT(make:make), 2) = make@row, RIGHT("0"+2,2) ,IF(INDEX(DISTINCT(make:make), 3) = make@row, RIGHT("0"+3,2) ,IF(INDEX(DISTINCT(make:make), 4) = make@row, RIGHT("0"+4,2) ,IF(INDEX(DISTINCT(make:make), 5) = make@row, RIGHT("0"+5,2) ,IF(INDEX(DISTINCT(make:make), 6) = make@row, RIGHT("0"+6,2) ,IF(INDEX(DISTINCT(make:make), 7) = make@row, RIGHT("0"+7,2) ,IF(INDEX(DISTINCT(make:make), 8) = make@row, RIGHT("0"+8,2) ,IF(INDEX(DISTINCT(make:make), 9) = make@row, RIGHT("0"+9,2) ,IF(INDEX(DISTINCT(make:make), 10) = make@row, RIGHT("0"+10,2) ,IF(INDEX(DISTINCT(make:make), 11) = make@row, RIGHT("0"+11,2) ,IF(INDEX(DISTINCT(make:make), 12) = make@row, RIGHT("0"+12,2) ,IF(INDEX(DISTINCT(make:make), 13) = make@row, RIGHT("0"+13,2) ,IF(INDEX(DISTINCT(make:make), 14) = make@row, RIGHT("0"+14,2) ,IF(INDEX(DISTINCT(make:make), 15) = make@row, RIGHT("0"+15,2) ,IF(INDEX(DISTINCT(make:make), 16) = make@row, RIGHT("0"+16,2) ,IF(INDEX(DISTINCT(make:make), 17) = make@row, RIGHT("0"+17,2) ,IF(INDEX(DISTINCT(make:make), 18) = make@row, RIGHT("0"+18,2) ,IF(INDEX(DISTINCT(make:make), 19) = make@row, RIGHT("0"+19,2) ,IF(INDEX(DISTINCT(make:make), 20) = make@row, RIGHT("0"+20,2) ,IF(INDEX(DISTINCT(make:make), 21) = make@row, RIGHT("0"+21,2) ,IF(INDEX(DISTINCT(make:make), 22) = make@row, RIGHT("0"+22,2) ,IF(INDEX(DISTINCT(make:make), 23) = make@row, RIGHT("0"+23,2) ,IF(INDEX(DISTINCT(make:make), 24) = make@row, RIGHT("0"+24,2) ,IF(INDEX(DISTINCT(make:make), 25) = make@row, RIGHT("0"+25,2) ,IF(INDEX(DISTINCT(make:make), 26) = make@row, RIGHT("0"+26,2) ,IF(INDEX(DISTINCT(make:make), 27) = make@row, RIGHT("0"+27,2) ,IF(INDEX(DISTINCT(make:make), 28) = make@row, RIGHT("0"+28,2) ,IF(INDEX(DISTINCT(make:make), 29) = make@row, RIGHT("0"+29,2) ,IF(INDEX(DISTINCT(make:make), 30) = make@row, RIGHT("0"+30,2) ,IF(INDEX(DISTINCT(make:make), 31) = make@row, RIGHT("0"+31,2) ,IF(INDEX(DISTINCT(make:make), 32) = make@row, RIGHT("0"+32,2) ,IF(INDEX(DISTINCT(make:make), 33) = make@row, RIGHT("0"+33,2) ,IF(INDEX(DISTINCT(make:make), 34) = make@row, RIGHT("0"+34,2) ,IF(INDEX(DISTINCT(make:make), 35) = make@row, RIGHT("0"+35,2) ,IF(INDEX(DISTINCT(make:make), 36) = make@row, RIGHT("0"+36,2) ,IF(INDEX(DISTINCT(make:make), 37) = make@row, RIGHT("0"+37,2) ,IF(INDEX(DISTINCT(make:make), 38) = make@row, RIGHT("0"+38,2) ,IF(INDEX(DISTINCT(make:make), 39) = make@row, RIGHT("0"+39,2) ,IF(INDEX(DISTINCT(make:make), 40) = make@row, RIGHT("0"+40,2) ,IF(INDEX(DISTINCT(make:make), 41) = make@row, RIGHT("0"+41,2) ,IF(INDEX(DISTINCT(make:make), 42) = make@row, RIGHT("0"+42,2) ,IF(INDEX(DISTINCT(make:make), 43) = make@row, RIGHT("0"+43,2) ,IF(INDEX(DISTINCT(make:make), 44) = make@row, RIGHT("0"+44,2) ,IF(INDEX(DISTINCT(make:make), 45) = make@row, RIGHT("0"+45,2) ,IF(INDEX(DISTINCT(make:make), 46) = make@row, RIGHT("0"+46,2) ,IF(INDEX(DISTINCT(make:make), 47) = make@row, RIGHT("0"+47,2) ,IF(INDEX(DISTINCT(make:make), 48) = make@row, RIGHT("0"+48,2) ,IF(INDEX(DISTINCT(make:make), 49) = make@row, RIGHT("0"+49,2) ,IF(INDEX(DISTINCT(make:make), 50) = make@row, RIGHT("0"+50,2)

IF(INDEX(DISTINCT(make:make), 1) = make@row, RIGHT("0"+1,2) ,

564

565

'=IF(Level@row = 1, IF(OR(ISBLANK([SQ1]#), [SQ1]# = "Num"), IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN1]#)), IF([SQ1]# = "Upper", IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN1]#)), IF([SQ1]# = "Lower", IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN1]#)))))),IF(Level@row = 2, IF(OR(ISBLANK([SQ2]#), [SQ2]# = "Num"), IF(OR(ISBLANK([LN2]#), [LN2]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN2]#)), IF([SQ2]# = "Upper", IF(OR(ISBLANK([LN2]#), [LN2]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN2]#)), IF([SQ2]# = "Lower", IF(OR(ISBLANK([LN2]#), [LN2]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN2]#)))))),IF(Level@row = 3, IF(OR(ISBLANK([SQ3]#), [SQ3]# = "Num"), IF(OR(ISBLANK([LN3]#), [LN3]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN3]#)), IF([SQ3]# = "Upper", IF(OR(ISBLANK([LN3]#), [LN3]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN3]#)), IF([SQ3]# = "Lower", IF(OR(ISBLANK([LN3]#), [LN3]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN3]#)))))),IF(Level@row = 4, IF(OR(ISBLANK([SQ4]#), [SQ4]# = "Num"), IF(OR(ISBLANK([LN4]#), [LN4]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN4]#)), IF([SQ4]# = "Upper", IF(OR(ISBLANK([LN4]#), [LN4]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN4]#)), IF([SQ4]# = "Lower", IF(OR(ISBLANK([LN4]#), [LN4]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN4]#)))))),IF(Level@row = 5, IF(OR(ISBLANK([SQ5]#), [SQ5]# = "Num"), IF(OR(ISBLANK([LN5]#), [LN5]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN5]#)), IF([SQ5]# = "Upper", IF(OR(ISBLANK([LN5]#), [LN5]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN5]#)), IF([SQ5]# = "Lower", IF(OR(ISBLANK([LN5]#), [LN5]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN5]#)))))),IF(Level@row = 6, IF(OR(ISBLANK([SQ6]#), [SQ6]# = "Num"), IF(OR(ISBLANK([LN6]#), [LN6]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN6]#)), IF([SQ6]# = "Upper", IF(OR(ISBLANK([LN6]#), [LN6]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN6]#)), IF([SQ6]# = "Lower", IF(OR(ISBLANK([LN6]#), [LN6]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN6]#)))))),IF(Level@row = 7, IF(OR(ISBLANK([SQ7]#), [SQ7]# = "Num"), IF(OR(ISBLANK([LN7]#), [LN7]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN7]#)), IF([SQ7]# = "Upper", IF(OR(ISBLANK([LN7]#), [LN7]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN7]#)), IF([SQ7]# = "Lower", IF(OR(ISBLANK([LN7]#), [LN7]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN7]#)))))),IF(Level@row = 8, IF(OR(ISBLANK([SQ8]#), [SQ8]# = "Num"), IF(OR(ISBLANK([LN8]#), [LN8]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN8]#)), IF([SQ8]# = "Upper", IF(OR(ISBLANK([LN8]#), [LN8]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN8]#)), IF([SQ8]# = "Lower", IF(OR(ISBLANK([LN8]#), [LN8]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN8]#)))))),IF(Level@row = 9, IF(OR(ISBLANK([SQ9]#), [SQ9]# = "Num"), IF(OR(ISBLANK([LN9]#), [LN9]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN9]#)), IF([SQ9]# = "Upper", IF(OR(ISBLANK([LN9]#), [LN9]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN9]#)), IF([SQ9]# = "Lower", IF(OR(ISBLANK([LN9]#), [LN9]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN9]#))))))

=IF(Level@row = 1, IF(OR(ISBLANK([SQ1]#), [SQ1]# = "Num"), IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN1]#)), IF([SQ1]# = "Upper", IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN1]#)), IF([SQ1]# = "Lower", IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN1]#)))))),IF(Level@row = 2, IF(OR(ISBLANK([SQ2]#), [SQ2]# = "Num"), IF(OR(ISBLANK([LN2]#), [LN2]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN2]#)), IF([SQ2]# = "Upper", IF(OR(ISBLANK([LN2]#), [LN2]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN2]#)), IF([SQ2]# = "Lower", IF(OR(ISBLANK([LN2]#), [LN2]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN2]#)))))),IF(Level@row = 3, IF(OR(ISBLANK([SQ3]#), [SQ3]# = "Num"), IF(OR(ISBLANK([LN3]#), [LN3]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN3]#)), IF([SQ3]# = "Upper", IF(OR(ISBLANK([LN3]#), [LN3]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN3]#)), IF([SQ3]# = "Lower", IF(OR(ISBLANK([LN3]#), [LN3]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN3]#)))))),IF(Level@row = 4, IF(OR(ISBLANK([SQ4]#), [SQ4]# = "Num"), IF(OR(ISBLANK([LN4]#), [LN4]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN4]#)), IF([SQ4]# = "Upper", IF(OR(ISBLANK([LN4]#), [LN4]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN4]#)), IF([SQ4]# = "Lower", IF(OR(ISBLANK([LN4]#), [LN4]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN4]#)))))),IF(Level@row = 5, IF(OR(ISBLANK([SQ5]#), [SQ5]# = "Num"), IF(OR(ISBLANK([LN5]#), [LN5]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN5]#)), IF([SQ5]# = "Upper", IF(OR(ISBLANK([LN5]#), [LN5]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN5]#)), IF([SQ5]# = "Lower", IF(OR(ISBLANK([LN5]#), [LN5]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN5]#)))))),IF(Level@row = 6, IF(OR(ISBLANK([SQ6]#), [SQ6]# = "Num"), IF(OR(ISBLANK([LN6]#), [LN6]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN6]#)), IF([SQ6]# = "Upper", IF(OR(ISBLANK([LN6]#), [LN6]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN6]#)), IF([SQ6]# = "Lower", IF(OR(ISBLANK([LN6]#), [LN6]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN6]#)))))),IF(Level@row = 7, IF(OR(ISBLANK([SQ7]#), [SQ7]# = "Num"), IF(OR(ISBLANK([LN7]#), [LN7]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN7]#)), IF([SQ7]# = "Upper", IF(OR(ISBLANK([LN7]#), [LN7]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN7]#)), IF([SQ7]# = "Lower", IF(OR(ISBLANK([LN7]#), [LN7]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN7]#)))))),IF(Level@row = 8, IF(OR(ISBLANK([SQ8]#), [SQ8]# = "Num"), IF(OR(ISBLANK([LN8]#), [LN8]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN8]#)), IF([SQ8]# = "Upper", IF(OR(ISBLANK([LN8]#), [LN8]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN8]#)), IF([SQ8]# = "Lower", IF(OR(ISBLANK([LN8]#), [LN8]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN8]#)))))),IF(Level@row = 9, IF(OR(ISBLANK([SQ9]#), [SQ9]# = "Num"), IF(OR(ISBLANK([LN9]#), [LN9]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN9]#)), IF([SQ9]# = "Upper", IF(OR(ISBLANK([LN9]#), [LN9]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN9]#)), IF([SQ9]# = "Lower", IF(OR(ISBLANK([LN9]#), [LN9]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN9]#))))))

IF(Level@row = 1, IF(OR(ISBLANK([SQ1]#), [SQ1]# = "Num"), IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), LC@row, RIGHT("000000000" + LC@row, [LN1]#)), IF([SQ1]# = "Upper", IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), CHAR(LC@row + 64), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 64)), [LN1]#)), IF([SQ1]# = "Lower", IF(OR(ISBLANK([LN1]#), [LN1]# = "Any"), CHAR(LC@row + 96), LEFT(SUBSTITUTE("^^^^^^^^^^", "^", CHAR(LC@row + 96)), [LN1]#)))))),

575

=SUM(

'=SUM(=IF(AND(91 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 91 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(93 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 93 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(94 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 94 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(100 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 100 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(101 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 101 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(103 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 103 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(104 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 104 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(110 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 110 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(111 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 111 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(113 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 113 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(114 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 114 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(120 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 120 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(121 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 121 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(123 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 123 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(124 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 124 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(130 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 130 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(131 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 131 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(133 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 133 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(134 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 134 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(140 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 140 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(141 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 141 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(143 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 143 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(144 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 144 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(150 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 150 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(151 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 151 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(153 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 153 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(154 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 154 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(160 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 160 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(161 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 161 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(163 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 163 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(164 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 164 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(170 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 170 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(171 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 171 <= VALUE(LEFT(SUBSTITUTE(End@

=SUM(=IF(AND(91 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 91 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(93 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 93 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(94 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 94 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(100 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 100 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(101 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 101 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(103 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 103 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(104 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 104 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(110 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 110 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(111 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 111 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(113 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 113 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(114 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 114 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(120 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 120 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(121 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 121 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(123 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 123 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(124 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 124 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(130 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 130 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(131 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 131 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(133 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 133 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(134 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 134 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(140 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 140 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(141 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 141 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(143 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 143 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(144 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 144 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(150 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 150 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(151 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 151 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(153 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 153 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(154 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 154 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(160 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 160 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(161 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 161 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(163 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 163 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(164 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 164 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(170 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 170 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)=IF(AND(171 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 171 <= VALUE(LEFT(SUBSTITUTE(End@r

=IF(AND(90 >= VALUE(LEFT(SUBSTITUTE(Begin@row, ":", ""), 2)), 90 <= VALUE(LEFT(SUBSTITUTE(End@row, ":", ""), 2))), 1, 0)

634

=IF(AND(84 >= VALUE(SUBSTITUTE(LEFT(Begin@row, LEN(Begin@row) - 1), ":", "")), 84 <= VALUE(SUBSTITUTE(LEFT(End@row, LEN(End@row) - 1), ":", ""))), 1, 0)

696

=IF([90]@row = 0, "Empty", IF([91]@row = 0, "Empty", IF([93]@row = 0, "Half", "Full")))

711

=IF([83]@row = 0, "Empty", IF([84]@row = 0, "Empty", IF([90]@row = 0, "Half", "Full")))

727

=LEFT(MID(Task@row, 3 * BarChars# + 1, BarChars#) + Fill#, BarChars#)

3 *

731

=IF([110]@row = 1, IF([103]@row = 0, [Bar1]@row, IF([100]@row = 0, [Bar2]@row, IF([93]@row = 0, [Bar3]@row, IF([90]@row = 0, [Bar4]@row, IF([83]@row = 0, [Bar5]@row, IF(Count@row > 5, Fill#, IF(Count@row > 6, Fill#, IF(Count@row > 7, Fill#, IF(Count@row > 8, Fill#))))))))))

110

103

100

754

=IF(cntm@row > 3, FIND(",", [Assigned To]@row, [c2]@row + 1))

> 3

[c2

772

=IF(cntm@row = 3, MID([Assigned To]@row, [c2]@row + 2, LEN([Assigned To]@row) - [c2]@row), IF(cntm@row > 3, MID([Assigned To]@row, [c2]@row + 2, [c3]@row - [c2]@row - 2)))

[c2

790

'=IF([9 AM]@row, IF(COUNTIFS(Created:Created, <Created@row, [Pick-up Date]:[Pick-up Date], [Pick-up Date]@row, [9 AM]:[9 AM], 1) = 0, 1, 0))

9 AM

796

=IF(ISTEXT([m1]@row), INDEX({Email}, MATCH([m1]@row, {Name}, 0)))

816

=IF(AND([S #]@row <= 6, 6 <= [E #]@row), 1, 0)

834

=IFERROR(INDEX(COLLECT([Row #]:[Row #], Successors:Successors, CONTAINS(Sep# + [Row #]@row + Sep#, @cell)), 1), "")

844

=IFERROR(INDEX(SUCCESSORS([Task Name]@row), 1,1), "")

855

=IFERROR(INDEX(Status:Status, [Pred 1]@row),"")

866

=IFERROR(IF(COUNTIFS(COLLECT([Row No]:[Row No], [p1]:[p1], 1), CONTAINS(@cell, [Suc 2]@row)) > 0, 1, 0), "")

875

=IFERROR(INDEX(COLLECT({List}, {List}, CONTAINS(@cell, [Multiple Dropdown List]@row)), 51), "")