Tag Info

New answers tagged

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 ...


0

I am able to achieve the colored background for progress bar based on task status. Used Status column instead of % Complete ="<DIV style='display:inline-block;position:relative;width:60px;height:17.5px;border:1px solid;'>" &"<DIV style='background-color:" &IF(Status="Blocked","red", IF(Status="Completed","limegreen", IF(Status="In ...


0

I ONLY copy/pasted your formula and only added linebreaks and spaces (which SharePoint ignores) in Notepad. Looking at this: There is a incorrect double quote at the end of the IF line The rest seems fine by me. ="<DIV style='display:inline-block;position:relative;width:60px;height:17.5px;border:1px solid;'>" &"<DIV ...


0

You have to be carefull with opening and closing quotes I copy/pasted your formula (start with 4 spaces so StackOverlfow displays it like code), only added some new lines and spaces for readablity =IF( ISBLANK([DS/F Attachment(s)]) ,"N/A" ,"="<a href='SiteURL/TaskerDocuments/" &[DS/F Attachment(s)] ...


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: ...


0

Got some internal help and produced this answer: =IF( LEFT(SUID,1)=";" ,MID(SUID,2,9) ,IF(LEN(TRIM(SUID))=0 ,"Enter SUID on Pickup" ,IF(AND(LEN(TRIM(SUID))>0 ,LEN(TRIM(SUID))<9) ,"Invalid SUID",SUID ) ) )


0

Not sure this will work in 2010, but in 2013 the simplest (and most limited) solution is to add a CEWP to the page, click Edit Source and add css to left align the header text: .ms-numHeader {text-align: left;} ...enclosed in style tags. Worked for me anyway...and thanks for the tip on how to left align the calculated field!


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 ...


0

The other answer is correct. I suggest to rewrite it a bit, more like your original formula If you are starting out with calculated columns it helps to keep them as short as possible and spread them over multiple lines. ="<img src=""/_layouts/15/images/kpidefault-" &IF([Completed]="In Progress","1", IF([Completed]="Yes","0","2")) ...


0

="<center>"&IF([Completed]="", "<img src='/_layouts/images/KPIDefault-2.GIF' border='0'/>",(IF([Completed]="In Progress","<img src='/_layouts/images/KPIDefault-1.GIF' border='0'/>", (IF([Completed]="Yes","<img src='/_layouts/images/KPIDefault-0.GIF' border='0'/>")))&"</center>" Remember to set the calculated column to ...



Top 50 recent answers are included