Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Return 1st Day of Month for a Date

Wanda T
Wanda T
edited 12/09/19 in Archived 2017 Posts

I am trying to avoid complex formulas however have not found a better work around.


Objective:  Column/Cell includes a Date, I would like a second column cell to return the Month for that cell



Column: Invoice  | Column:  SchedMos 

 May 15, 2016      |   May 1, 2016  =Mos(Invoice1)

 June 22, 2017    |  June 1, 2017



I am familiar with the @Month and @Year formulas and can create three new columns (one for Month, one for Year and a third with a formula) to try to get to the outcome I need, however the formula becomes extremely long with IF, then (12 per year).


Any ideas?  I might have missed something



This discussion has been closed.