Summary Formula to Show New Value Each Day

I have a sheet that tracks new employees by type. Within my sheet, I have a date column and employee type columns (example: Intern). I'd like to create a Summary formula within the sheet that will return the number of interns each day. Or a formula that will return the last entry in that column. How can I do that?


Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    @Andrea Westrich

    Ah! This helps give some clarity. This sheet only has interns on it. In this case, let's try this:

    =INDEX([# of interns]:[# of interns], MATCH(TODAY(), Day:Day, 0))

    That should do the trick. Make sure your Day column is set as a date column in column properties. Let me know if it works!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!