The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
25 views

How to store IP Address and very large int account numbers in list? What types are best

I'm making a list and need to store IP Addresses and Account Numbers. Basically the text or single line of text variable looks best at the moment however I am wondering if anyone else knows a better ...
1
vote
3answers
39 views

Conditional Formatting Based on Number Range

I'm trying to add conditional formatting to a custom list based on whether or not a field contains a number in a certain range (i.e., if the field contains a number less than 15, i'd like the ...
0
votes
2answers
33 views

Number SharePoint list items always starting at the top with 1, 2, 3

I need to add a field to a SharePoint list which always numbers the list items viewed on the page starting at the top with 1, 2, 3... The top row would always be number "1". Is there any way to do ...
1
vote
2answers
129 views

How to set only positive number in sharepoint 2013 column

The column Title has default setting as single line text. I would like to set validation as only positive numbers allowed, no decimal. I've tried with =ISNUMBER(PurchaseQty+0) but I still can key in ...
0
votes
1answer
60 views

How to validate the total value of multiple Number columns in a list?

In a List, I've got several number columns that users enter a value in for # of tickets. Ex: Event 1 - [ ] tickets Event 2 - [ ] tickets Event 3 - [ ] tickets Is it possible to validate the ...
0
votes
1answer
107 views

Content Editor - ordered list second level

I wanted to create multilevel ordered list in SharePoint 2013 Content Editor, with continuous counting, including numbers from upper levels. 1. Planes 2. Cars 2.1. Ferrari 2.2. BMW 3. Trains ...
3
votes
2answers
6k views

Remove comma (thousands seperator) in number field without using calculated item

Is there a way to achieve this without adding a calculated item with this format = TEXT([Customer Number], "0") ?? I'm using sharepoint 2013.
0
votes
1answer
31 views

Simple List item ID Auto-population

I have a list that I want to go up by one number automatically for each new item, the first item would be 1, then 2, and so on. I have seen a lot of solutions out there for solution to auto-number a ...
3
votes
2answers
572 views

Best practice for autonumber

What is in SharePoint 2013 on premise the best way to create an autonumber system? It's for an expense note system and it should be nice to have something like 2014/0001. I know there are different ...
2
votes
1answer
59 views

How do I get a placeholder of 0?

I want my InfoPath form to have numbers formatted like "010" instead of "10" to then sync with SharePoint. How can I get my form to show the zero placeholder instead of two digits?
1
vote
1answer
436 views

Currency Data in a Workflow variable rounds to nearest dollar, want to have cents, too

I have one list called Capital Projects with Orig Budget, Amount Spent, Amount Left. I have another list with invoices with Invoice number and TotalAmount. I wrote a workflow that runs every time an ...
1
vote
2answers
870 views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
0
votes
0answers
102 views

Calculated Column returns excessive amount of zeros

In a Purchase Order form I'm putting together, I have line amount and total amount as calculated columns. However, when displayed in the InfoPath form, they show with a ridiculous amount of zeros at ...
0
votes
1answer
26 views

Making a number of items in one list by the entered value in another list

I have two lists. In one list I have a variable that is a number. When I put certain number (for an example 5) in that variable, I want to make that many (in this case 5) items in another list. The ...
0
votes
1answer
321 views

Programmatically adding a sequence number to the 'Title' column during item creation in SP List

As per the title above, I have a list that stores IT support requests. I need a sequence number that matches with the item ID and I want to add this sequence number to the Title of the request. I ...
1
vote
1answer
450 views

User input issue with Locale change of Site SP 2010

My site is running under SharePoint 2010. Everything is Ok except when I change the locale of my site from Regional settings from US (English) to Malay. The my web part pages where user has number ...
2
votes
2answers
7k views

Creating an Autonumber Column

Is there a way to create an autonumber column in the lists and libraries? For example I want to have a list and when a user wants to add a new value, it automatically generates a new autonumber.
3
votes
1answer
4k views

Converting number field to text field results in data loss

I have the following scenario: A standard generic list with a number column. There is a large number of list items in the list - 200000. All list items have an integer number value (no floating point)...
0
votes
1answer
1k views

XSLT for summing Number column where there are cells with no value

This is akin to this question but I couldn't get the suggested sumAll function to work. I also have several different columns to sum and it just seems silly to have a separate template for each ...
2
votes
2answers
173 views

Should I use SharePoint Number column types to store monetary values?

In SharePoint I can create a list column of type 'Number'. I need to store monetary amounts and would like to be able to use this column type rather than having to create a new one. Are values of ...