Questions tagged [number]
The number tag has no usage guidance.
34
questions
0
votes
1
answer
49
views
SharePoint Online Pre-Pend Number column with PowerShell
Through the UI its possible to pre-pend a number column - See screenshot below:
How can this pre-pended text be changed or added with PowerShell?
- 1,533
0
votes
1
answer
61
views
Flow Not Returning Desired Results
I have a recurring Flow that kicks off once a day to test a List to see if any of the 'Titles' have a 'DueDate' that equals 30 days, if yes send an email.
I have two variables:
Name: varNumberOfDays
...
1
vote
1
answer
60
views
Number formatting
I have a two choice columns that display same three choices: 0, 3, 9
Column 1 has a value of 9
Column 2 has a value of 3
I want to add 9 and 3 on a new column.
Something so simple is giving me issues?
...
- 101
0
votes
2
answers
63
views
Add a seach box to an integer column in SP online list
Is there a way to add a search-box for a column with type of Number in a SharePoint online list?
It seems this functionality is only available for columns with the type of "single line of text&...
- 425
1
vote
0
answers
45
views
Flow not resolving round value for a number field
In flow, I am using actions below:
Get items
Select action using data from above action
Inside select, I am using custom headers and mapping it to dynamic values coming from SP as shown below.
...
- 1,225
1
vote
1
answer
126
views
Camel Query OrderBy not working for Decimal Number
I have column name OrderBy of Type Number:
I am using below CAML Query:
"<View><Query><OrderBy><FieldRef Name='OrderBy' Ascending='TRUE' />
</OrderBy></Query>&...
- 3,392
1
vote
0
answers
1k
views
Sharepoint List - Number as percentage with default value setting
I'm working on a PowerApp linked to a list as data source and I get weird display on every number displayed as a percentage (x100).
I'm trying to set a number column/field with a value between 0 and ...
- 143
0
votes
2
answers
2k
views
Calculated column - extract only the number from alpha numeric string
I have a alpha numeric column which has values like "XGS000042210" or "XGS000836485".
How do I extract the number part alone omitting the zeros using calculated column?
For eg: If the column values ...
- 1,502
0
votes
2
answers
2k
views
How to force a number field to keep zeros at the start?
I would like to use a number field to add phone number to a Sharepoint list. But if the phone number starts with 0, it is automaticly removed by default. Is there any way to keep it? I didn't want to ...
- 319
0
votes
1
answer
190
views
Setting Default value for drop down based on a number field.
I have a simple request from my manager to make a change in the default Edit Form for a share point list.
I have a number field which allows one decimal value and a drop down field with dedicated, ...
1
vote
2
answers
201
views
Is it possible tpo use the excel weeksum function in SharePoint to return the week number from a date column?
I am new to SharePoint and I know that in Excel you can use the WEEKSUM function to return the week number from a date column. Is it possible to do the same in SharePoint 2013? If so how can this be ...
- 11
1
vote
2
answers
3k
views
Enabling dashes (hyphens) in a number column in SharePoint
How do you allow dashes (hyphens) to be used in a number column in SharePoint?
SharePoint only allows numbers and nothing else in number columns.
Is there a formula or a calculated column that can be ...
- 145
1
vote
0
answers
207
views
Only Integers (List Validation Settings) with condition
I just discovered the Validation Settings and think they are so helpful!
I implemented column validations that check if the number is an integer but now that gives me an error with my workflow (...
- 215
3
votes
0
answers
859
views
Display SharePoint version in word documents for Content types
I have a requirement to show the version number in the word document in SharePoint 2013. For which I enable the Label in "Information Management Policy Setting" by following this URL http://www....
- 31
2
votes
1
answer
309
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 ...
2
votes
3
answers
1k
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 ...
- 23
0
votes
2
answers
99
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 ...
- 40
1
vote
2
answers
2k
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 ...
- 453
0
votes
1
answer
1k
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 ...
- 1
0
votes
2
answers
2k
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
...
- 768
18
votes
5
answers
58k
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.
- 357
0
votes
1
answer
75
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 ...
- 51
3
votes
2
answers
12k
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 ...
- 167
2
votes
1
answer
328
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?
- 21
1
vote
1
answer
1k
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 ...
- 11
1
vote
2
answers
2k
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 ...
- 1,073
0
votes
0
answers
254
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 ...
- 153
0
votes
1
answer
29
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 ...
user18277
0
votes
1
answer
441
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,157
1
vote
1
answer
618
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 ...
- 763
2
votes
2
answers
9k
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.
- 157
4
votes
1
answer
9k
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)...
- 242
0
votes
1
answer
2k
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 ...
- 123
2
votes
2
answers
411
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 ...
- 141