PS03 - Lists - Add New Calculated Column

[Matt Piazza, PMP]

I need a field that shows how many days since an issue item was created. I
created a new calculated column with [created] and [status date] (another
custom field). Unfortunately, I have to update the [status date] field for
each open issue item each Monday morning. I tried [today] instead of [status
date], but no success.

Has anyone created a dynamic calculated column formula that subtracts one
fixed date [created] from a dynamic date [today]?

 

[Ben Howard]

Hi Matt,
I've had partial success on this, such that I can calculate the days
automatically, but the problem is that WSS will only recalculate this when
you edit the issue, so if you have 20 issues, you have to edit each one.
Also, its a bit of a fudge to set it up, but it works. Due to the recalc
issue, I ended up solving the issue with an SRS report instead.

I've just spent a 1/2 hour looking for the code I wrote, but cannot fnd it
Worth searching for [today] on the sharepoint sites. I remember one of
the sharepoint MVPs providing the fudge for the calculated field. If I find
anything else I'll post it here.

 

[Matt Piazza, PMP]

Thanks for your fast response. If you find the code, GREAT; maybe I will get
some more experience with the SRS report idea.
--
Matt in Flower Mound Texas

Hi Matt,
I've had partial success on this, such that I can calculate the days
automatically, but the problem is that WSS will only recalculate this when
you edit the issue, so if you have 20 issues, you have to edit each one.
Also, its a bit of a fudge to set it up, but it works. Due to the recalc
issue, I ended up solving the issue with an SRS report instead.

I've just spent a 1/2 hour looking for the code I wrote, but cannot fnd it
Worth searching for [today] on the sharepoint sites. I remember one of
the sharepoint MVPs providing the fudge for the calculated field. If I find
anything else I'll post it here.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

I need a field that shows how many days since an issue item was created. I
created a new calculated column with [created] and [status date] (another
custom field). Unfortunately, I have to update the [status date] field for
each open issue item each Monday morning. I tried [today] instead of [status
date], but no success.

Has anyone created a dynamic calculated column formula that subtracts one
fixed date [created] from a dynamic date [today]?

 

[Ben Howard]

I think from memory, you have to create a field called Today, then use that
in your calculation (I was calculating proximity of risks), ie proximity =
risk due date - [today]. Then delete the Today field, and it reverts to
using the [today] field. Then I ordered and grouped the WSS list by
proximity along the lines of
=IF(Proximity<0,"-1
Overdue",IF(Proximity<=7,"0-7",IF(Proximity<=14,"08-14","15+")))
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Thanks for your fast response. If you find the code, GREAT; maybe I will get
some more experience with the SRS report idea.
--
Matt in Flower Mound Texas

Hi Matt,
I've had partial success on this, such that I can calculate the days
automatically, but the problem is that WSS will only recalculate this when
you edit the issue, so if you have 20 issues, you have to edit each one.
Also, its a bit of a fudge to set it up, but it works. Due to the recalc
issue, I ended up solving the issue with an SRS report instead.

I've just spent a 1/2 hour looking for the code I wrote, but cannot fnd it
Worth searching for [today] on the sharepoint sites. I remember one of
the sharepoint MVPs providing the fudge for the calculated field. If I find
anything else I'll post it here.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

I need a field that shows how many days since an issue item was created. I
created a new calculated column with [created] and [status date] (another
custom field). Unfortunately, I have to update the [status date] field for
each open issue item each Monday morning. I tried [today] instead of [status
date], but no success.

Has anyone created a dynamic calculated column formula that subtracts one
fixed date [created] from a dynamic date [today]?

 

[Matt Piazza, PMP]

I will try this technique, creating a custom field ... then deleting the
custom field. You are very clever to discover this technique.

Have a fun and safe July 4th Holiday! ;-)
--
Matt in Flower Mound Texas

I think from memory, you have to create a field called Today, then use that
in your calculation (I was calculating proximity of risks), ie proximity =
risk due date - [today]. Then delete the Today field, and it reverts to
using the [today] field. Then I ordered and grouped the WSS list by
proximity along the lines of
=IF(Proximity<0,"-1
Overdue",IF(Proximity<=7,"0-7",IF(Proximity<=14,"08-14","15+")))
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/

Thanks for your fast response. If you find the code, GREAT; maybe I will get
some more experience with the SRS report idea.
--
Matt in Flower Mound Texas

Hi Matt,
I've had partial success on this, such that I can calculate the days
automatically, but the problem is that WSS will only recalculate this when
you edit the issue, so if you have 20 issues, you have to edit each one.
Also, its a bit of a fudge to set it up, but it works. Due to the recalc
issue, I ended up solving the issue with an SRS report instead.

I've just spent a 1/2 hour looking for the code I wrote, but cannot fnd it
Worth searching for [today] on the sharepoint sites. I remember one of
the sharepoint MVPs providing the fudge for the calculated field. If I find
anything else I'll post it here.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



:

I need a field that shows how many days since an issue item was created. I
created a new calculated column with [created] and [status date] (another
custom field). Unfortunately, I have to update the [status date] field for
each open issue item each Monday morning. I tried [today] instead of [status
date], but no success.

Has anyone created a dynamic calculated column formula that subtracts one
fixed date [created] from a dynamic date [today]?