Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

WSS V2 Calculated Column

  Asked By: Naman    Date: Jun 05    Category: Sharepoint    Views: 1433

When I attempt to use the following formula to define a calculated
column, it throws up on the use of TODAY...

=IF ([Status] = "Completed", [Modified] - [Created] , TODAY-[Created])

Any suggestions?



4 Answers Found

Answer #1    Answered By: Allyson Burgess     Answered On: Jun 05

I know I saw a trick to that somewhere..

It had to do with creating a blank column  in your list called "today."

Then what you do is create your calculated  column using the today  column
you just created. Once that is done, you can delete the first "today"

I know this works in v3, it should work in v2 as well.

Answer #2    Answered By: Vinay Thakur     Answered On: Jun 05

I just read this post yesterday:

hope this works

Answer #3    Answered By: Elaine Mack     Answered On: Jun 05

I briefly looked at that link..

It looks very much like what I had found earlier..but not sure if it was
for v2 or v3..

Answer #4    Answered By: Baiju Hoskeri     Answered On: Jun 05

This was commonplace in WSS v2 and still works in WSS v3. You can use a
temporary column  called Me to stub in for [Me] in a formula  too.

Didn't find what you were looking for? Find more on WSS V2 Calculated Column Or get search suggestion and latest updates.