Linked Questions

41
votes
16answers
22k views

June 13th 2017 Microsoft blocked handling HTML markup in SharePoint calculated fields - how to get the same functionality back

On June 13th 2017 all SharePoint calculated columns with HTML markup stopped working. Basically the fields now render text (regardless of setting the data type to number). The gist of the notice ...
16
votes
5answers
52k views

How to get current user with javascript?

I have a list . I want select items of list with a special quary.(get items that created with current user). Then get count of items. I use this code for get current user : function Initialize() { ...
8
votes
4answers
11k views

Getting less than (Today+7) days items using caml query

I want to retrieve items from list which are lessthan seven days from today date. Today date:12/14/2015 seven days means: 12/21/2015. Using caml query. can anybody know please tell me.
4
votes
4answers
33k views

How to get Full Name in 'Calculated Column' from User Id in SharePoint List

I have a list with a column which consist of user id. there is also a calculated column which has to get the full name from this id. I was able to achieve this by installing custom WSP. Is there any ...
3
votes
2answers
2k views

How to use relative DateTime format like '2 days ago'/'Thursday', etc

I am updating a list and it's views (put together by another developer) and am adding a new date column. Currently, there is/was an existing date column (in this case called Orig Due Date), and I ...
1
vote
2answers
27k views

Calculated column with today's date based on other columns

I've been struggling with the calculated column in SharePoint. I would like to have a column in which the date is calculated from the values in two other columns. I have one column named "Status", a ...
1
vote
3answers
2k views

Count not updating in calculated column

I am getting number of days between Created & Now in SharePoint 2010 list using calculated column by below mentioned formula. =IF(ISERROR(DATEDIF(NOW(),Created,"d")),DATEDIF(Created,NOW(),"d")) ...
8
votes
1answer
6k views

Filter “Modified” by previous week

Want to filter list items that were modified on last week Think pseudocode for this will be Modified >= ( [Today]-WEEKDAY-7 ) && Modified <= ( [Today]-WEEKDAY ) No matter what day of ...
0
votes
3answers
9k views

calculated formula for date in sharepoint

I have a date field "Start date" and want to create calculated field based on below condition If start date is less than current date enter value "Progress" If start date is greater than current date ...
2
votes
1answer
6k views

Date column with default value as calculated value that gives the next Wednesday

I have a List Column that is Date only. I would like it to default to the next Wednesday (or today if today is Wednesday). What can I put in the Calculated Value field so that it defaults to ...
2
votes
2answers
2k views

How do I add hours to Now() after converting it to a text value?

I have a calculated field that shows the text value of the current hour, so I'm using: =TEXT(Now(), "hh") Unfortunately, it's showing this value in Pacific time, so I'd like to add 3 hours to ...
3
votes
3answers
3k views

SharePoint views - Filtering by date and time

We have a custom web-part that uses a View to filter Procurements (Tenders) by date. We are trying to filter the view using the [Today] function but from what I gathered it only uses the Date and ...
2
votes
2answers
3k views

How to do SharePoint calculated column due date calculation?

We have a SharePoint 2013 list column 'Expiry Date' and we need to calculate overdue by days. For eg, if expiry date is 1/8/2017 and Overdue by days should be 158. How to achieve this? thanks in ...
1
vote
1answer
4k views

Which Excel functions are not supported by SharePoint calculated columns?

This MSDN article lists various functions that can be used in SharePoint calculated columns, and also includes the following disclaimer: Note Microsoft SharePoint Foundation formulas for ...
0
votes
1answer
965 views

Calculated formulas for tracking progress

I would like to let my team know if their document is progressing on track. I have a start date and due date and a column that they must enter their progress %. In a tracking column I would like to ...

15 30 50 per page