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.

    I need a formula to count how many times a Employee is trained each month

    ✭✭✭
    in Formulas and Functions
    image.png

    If a associate has multiple entry dates in a month that would the amount of time they was trained. Thanks in advance!

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Best Answers

    • ✭✭✭✭✭✭
      Answer ✓

      Is it ok to assume that this is a master sheet and you are looking for the count in another sheet where you have the Associate Name column and Column for Month that will be used to check the criteria?

      If not then I would recommend creating helper formula column for month based on "Entry Date", and then create a report where you can group by the new month column and associate name, and summarize by associate name.

      · Share on FacebookShare on Twitter
    • Community Champion
      Answer ✓

      Adding to Sameer's advice above, the formula below could be used if you would like to see the information in the sheet itself.

      image.png


      · Share on FacebookShare on Twitter

    Answers

    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