Tag Info

Hot answers tagged

2

Nicole, Danny's solution should also work. If you want to keep it in one formula, this should work. =IF(LEFT(SUID,1)=";",IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Enter the SUID on Package ...


2

It is easier if you build your Formula in partials/multiple Calculated Formulas, you can add a maximum of 48 Calculated Columns to a List and you don't have to use everyone in a View or Form. So create a separate Column "NumberStripping" with you Formula RIGHT(LEFT(SUID,FIND("=",SUID)-1),LEN(LEFT(SUID,FIND("=",SUID)-1))-1) That is the part you want to ...


1

You don't actually have a value in your NameAndTitle field; you have a lookup that gets the values from two other fields. Sounds like you want to abstract that again -- a lookup on a lookup? That doesn't work in SharePoint. You have to write the value you want to the NameAndTitle field -- if you have SQL access you can do it with a trigger. Otherwise, you ...


1

Your lastname field must be the title field of the list you have repurposed. This is because the PlaceHolderPageTitle content placeholder on the list's dispform.aspx uses Title field as the default. You can change it easily using SP Designer. Open the Dispform.aspx for the list and make the below replacement on the existing PlaceHolderPageTitle field: ...



Only top voted, non community-wiki answers of a minimum length are eligible