Tag Info

New answers tagged

0

You get December for an empty date becuase SharePoint starts counting dates at 31 december 1899 Your formula is almost correct, just some typos: This should work: (I added some spaces for clarity) =IF( ISBLANK([Date]) , "" , TEXT([Date],"mmm") )


1

Try =IF(ISBLANK([Date]), "", TEXT([Date], "mmm"))


0

There is no direct function which can give you this value. You can calculate this based on Find number of weeks between January and April Find number of weeks from your Date Field and January Now Add Result of #1 wit Result of #2 You can find week from date using formula ...


1

You need two calculated columns and apply filter Start of the Month =DATE(YEAR(DateField),MONTH( DateField),1) End of the Month =DATE(YEAR( DateField ),MONTH( DateField)+1,1)-1 Filter "Start of the Month" is Less than or Equle to [Today] Or "End of the Month" is Greater than or Equal to [Today]


1

A formula like this should do the trick. =CONCATENATE(MONTH(DATE_FIELD_NAME),"/1/",YEAR(DATE_FIELD_NAME))


1

Try this formula: =CONCATENATE(MONTH([Date]),"/1/",YEAR([Date]))


1

=[START DATE]+[ETC] + ROUNDDOWN([ETC]/5,0)*2 + IF(WEEKDAY([START DATE])+MOD([ETC],5)>=7,2,0) - ROUNDDOWN(WEEKDAY([START DATE])/7,0) + IF(AND(MOD([ETC],5)=0,WEEKDAY([START DATE])=1),-2,0) + IF(AND(MOD([ETC],5)=0,WEEKDAY([START DATE])=7),-2,0) Here's where I copied this from.


0

If the sitename before the Statename is fixed you can get everything after SPDev/ with: =MID( [Col] , FIND("SPDev/", [Col] )+6 , 255) +6 is the length of SPDev/ You then have to get the string length up to the first / (after the Statename) =FIND( "/" , MID( [Col] ,FIND("SPDev/", [Col] )+6,255) )-1 All together in one Formula: =MID( [Col] ...


1

Create a calculated column and set the return type to Single line of text. If the URL path until Arizona is constant, then add the below formula =LEFT(RIGHT([Column Name],LEN([Column Name])-36),FIND("/",RIGHT([Column Name],LEN([Column Name])-36))-1) Replace the column name and Number "36" based on the number of characters before the text "Arizona".


0

Set the data type to Single line of text and add the below formula =YEAR(Created)&AutoID


0

You'll need to base the value of the year on the record's created date if you want it to reflect the current year. And, assuming your "AutoID" field works and increments as expected, your formula would be as follows: =YEAR(Created)&AutoID



Top 50 recent answers are included