I am using an InfoPath form that has a field which changes value. How do I create a column that only reflects the very first value despite all the changes done. I am on SharePoint Online by the way. Indy011910F
I have 2 column: Expiring Date and Status With condition if: I use formula: =IF(And([Expiring Date] <= Today(), [Expiring Date] <= Today())), “Active”, “Inactive”) But show message error: Sorry, something when wrong. Please correct my formula...
Though I am a huge advocate ofmetadata, one column type that I have never blogged about previously is theLookup column in SharePoint. The reason for this is that it is a unique type of column you would only use in very rare scenarios, and it does come with limitations. But it can be...
term store, text, etc.) One column I have not written about yet is theCalculated Column. So let me fix that injustice and explain to you what it is and how to create a Calculated Column in a SharePointlist or library
Hi Everyone, I am facing one issue last 4days...plzzzzzz help me in this when I used the Calculated column formula like =CONCATENATE("0001-",REPT(0,3-LEN(ID+1)),ID+1)...(modified version) Output...
I have to say,it is a awesome Function and easy for sharepoint end users.So,Let me guide you through this .And,more remarkable,as long as you must stay in the same site collection.You can create a lookup Site Column that will be used to get information from list which is av...
Column ordering option is for newform/editform pages but for display form you need to change position in view.Hope it could helpHemendra:Yesterday is just a memory,Tomorrow we may never see Please remember to mark the replies as answers if they help and unmark them if they provide no help...
Automatically importing a csv file to a SharePoint list BCS WCF - The username is not provided. Specify username in ClientCredentials. Best way to "flatten" a deeply nested folder structured document library? Bulk Find and Replace text on SharePoint pages Calculated column in list to turn a ...
Sign in to vote hi, Currently am using this code to print the list item on console with values in this way Title: Name: Address: City: 1 Ram xyz Delhi But it prints like column...
Inserting a row or column Sorting Performing calculations Copy and pasting Opening or closing the workbook Running VBA If you're seeing the error when performing any of the above actions, it's time to look to determine what's going on in your file. These are addressed in the sections below...