NutritionGal2005 · Menu Development and Project Director · ✭✭

Overview

Overview

Roles	Member
Badges	3

About Me

About Me

Title	Menu Development and Project Director
Area of Expertise	Healthcare Food Service Database

Analytics

5

Posts

16

Visits

45

Points

Jun 2, 2023

Join Date

Mar 11, 2024

Last Active

Reactions

No reactions yet.

• Discussions2
• Comments3

Discussions

• Count number of each day of the week occur in a certain month

  I want to type the month/year in a cell and have formulas to tell me how many Sundays, Mondays, Tuesdays etc are in that month. I'm currently entering that manually. Is there a way?

  

  Answered ✓

  Formulas

  Formulas and Functions

  2697

  Mar 4, 2024

  3

• I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula

  Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that…

  

  Answered ✓

  Formulas

  columns

  Formulas and Functions

  403

  Jun 6, 2023

  6