Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Using symbols for assigned to

    ✭✭✭
    in Formulas and Functions

    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?

    image.png
    Tags:
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      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
      melissa@insightfulsheets.com
      Data made simple, spreadsheets reimagined

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      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
      melissa@insightfulsheets.com
      Data made simple, spreadsheets reimagined

      · Share on FacebookShare on Twitter
    • ✭✭✭

      @melissa@insightfulsheets.com thank you that worked perfectly

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭

      Happy to help! 😊

      Melissa Yamada
      melissa@insightfulsheets.com
      Data made simple, spreadsheets reimagined

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions