locked
Calculated column Today +

    Question

  • I created a calculated column CALC REV that shows date a document needs to be reviewed.  I want to create another calculated column that says =IF([Calc Rev]<=TODAY()+14,"REVIEW")  If it cannot be based on Calc Rev column, I could base on date column of when document was created.  What am I doing wrong?  Can this be done - thanks.
    Sunday, January 22, 2012 11:06 PM

Answers

  • Hi,

    2 things here.  Firstly you cannot use [Today] in a calculated column (there is a work around) and secondly a calculated column is only calculated when an item is created or edited.  So even if you get around the Today issue your formula wouldn't check every day to see if it needs to be reviewed.

     

    Your best option here is to use a workflow.  You could set the workflow to set the column to review after 14 days or even get it to email the person/group to notify that its due for review.

     

    Hope that helps.

    Brian

    Monday, January 23, 2012 9:28 AM
  • Thanks - I finally figured it out.  Instead, I just set a filter in a view - accomplishes what I wanted and very simple.
    karen burgess
    Monday, January 30, 2012 3:00 AM

All replies

  • Once again someone has posted a reply giving a link to an article about SP 2010 to a thread in a pre-SP 2010 forum.

    I have of course deleted it as off-topic.

    You know who you are. Stop doing this and only give pre-SP 2010 (thus typically SP 2007) answers to questions that have been posted to a pre-SP 2010 forum.

    Moderator pre-SP 2010 forums.


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, January 23, 2012 8:05 AM
  • Hi,

    2 things here.  Firstly you cannot use [Today] in a calculated column (there is a work around) and secondly a calculated column is only calculated when an item is created or edited.  So even if you get around the Today issue your formula wouldn't check every day to see if it needs to be reviewed.

     

    Your best option here is to use a workflow.  You could set the workflow to set the column to review after 14 days or even get it to email the person/group to notify that its due for review.

     

    Hope that helps.

    Brian

    Monday, January 23, 2012 9:28 AM
  • Monday, January 23, 2012 10:03 AM
  • @Anil - that fake today trick does not work -  http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/

    This blog post gives you a few options

    http://blog.pentalogic.net/2011/05/how-use-today-in-a-sharepoint-list/

    * CEWP and JavaScript

    * SharePoint Designer & XSLT Data View

    * Code

    * Highlighter - Commercial product (disclaimer, this one is my own companies product)


    Pentalogic Technology - Web Parts for Microsoft SharePoint www.pentalogic.net
    • Edited by Pentalogic Tuesday, January 24, 2012 1:24 PM added extra info
    Tuesday, January 24, 2012 1:20 PM
  • > This blog post gives you a few options

    What a great pity that that blog item is nothing more than a major advert for a Pentalogic product.

    If you want your posts not to be deleted as adverts start posting links to pages that provide information and do NOT advertise your products.

    Moderator


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Tuesday, January 24, 2012 2:09 PM
  • Mike - thats hardly fair. 

    That post gave 4 options, one mostly about 2010 so we can discount for this thread.

    Two of them are valid (and free) options with full links to give more details and yes one does mention our product and I fully disclosed this and it takes up only 14% of the words on that page. Nothing more than an advert? 

    Ryan.


    Pentalogic Technology - Web Parts for Microsoft SharePoint www.pentalogic.net
    Tuesday, January 24, 2012 2:43 PM
  • It would have been a good URL to refer to even if on your company's site IF it had no advert content.

    You should learn to keep information posts and advert posts separate and then there would be no complaints from my part when you refer to the *information* post. [You then rely on people looking at the rest of your site once attracted to the site by the information content].

    I also didn't think much of the way the advert section was written. Information it wasn't - overdone marketing it was.

    You already mentioned that product in your post in the forum. There was no need to also send people to a web page where it (even with 14% of the words) dominated.

    Mike


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Tuesday, January 24, 2012 2:48 PM
  • Thanks - I finally figured it out.  Instead, I just set a filter in a view - accomplishes what I wanted and very simple.
    karen burgess
    Monday, January 30, 2012 3:00 AM