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.

Month/Year to text

johnking21406

johnking21406 ✭

08/18/17 edited 12/09/19 in Archived 2017 Posts

I am trying to extract the month and year out of a date column and join them to create a unique key. For example

the value in the date column is 8/18/2017

I need a formula to return 82017

I can extract the month and the year without a problem, but when I try to combine them I get the sum of 8 and 2017.

Tags:

0 ·

Comments

johnking21406 ✭

08/18/17

I figured it out:

=LEFT([Start Date]7, 2) + MID([Start Date]7, 7, 2)

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day