Using symbols for assigned to

TPALJA

is there a formula that automatically displays the person icon based off of the number of resources in the assigned to column vs using the drop down?

Melissa Yamada

Hello @TPALJA

A possible solution is create a helper column that will count the # of contacts on your Assigned To column using the COUNTM function.

Sample formula on your helper column:

=COUNTM([Assigned To]@row)

Then on your Resource column, you'll create a series of IF statements:

=IF([Column8]@row = 0, "Empty", IF([Column8]@row = 1, "One", IF([Column8]@row = 2, "Two", IF([Column8]@row = 3, "Three", IF([Column8]@row = 4, "Four", IF([Column8]@row = 5, "Five"))))))

However, the max value for the resource symbol is up to 5 only if your Assigned To column is greater than 5 it will not be able to return a symbol just the numerical value.

Melissa Yamada

Hello @TPALJA

A possible solution is create a helper column that will count the # of contacts on your Assigned To column using the COUNTM function.

Sample formula on your helper column:

=COUNTM([Assigned To]@row)

Then on your Resource column, you'll create a series of IF statements:

=IF([Column8]@row = 0, "Empty", IF([Column8]@row = 1, "One", IF([Column8]@row = 2, "Two", IF([Column8]@row = 3, "Three", IF([Column8]@row = 4, "Four", IF([Column8]@row = 5, "Five"))))))

However, the max value for the resource symbol is up to 5 only if your Assigned To column is greater than 5 it will not be able to return a symbol just the numerical value.

TPALJA

@melissa@insightfulsheets.com thank you that worked perfectly