4 New Messages
Digest #4506
| |
Messages
Tue Aug 21, 2012 6:12 am (PDT) . Posted by:
"catisbell01" catisbell01
I need to create a calculated column using the DATEDIF. The problem comes from if the item is completed before the due date it creates a negative number. This is fine except that Sharepoint view the negative number as an error. #NUM!. How can I create the calculated column to show me the negative numbers. I use these to track metrics to see if we are ahead of schedule.
Current formula being used is =DATEDIF(Due,[AF],"D")
Current formula being used is =DATEDIF(Due,
Tue Aug 21, 2012 8:21 am (PDT) . Posted by:
"Cheetham, Phillip" phillip_cheetham
This works in Excel: =IF(MIN(Due,[AF])=Due,DATEDIF(Due,[AF],"D"),-(DATEDIF([AF],Due,"D")))
From: sharepointdiscussions@yahoogroups.com [mailto:sharepointdiscussions@yahoogroups.com ] On Behalf Of catisbell01
Sent: Monday, August 20, 2012 6:43 PM
To: sharepointdiscussions@yahoogroups.com
Subject: [sharepointdiscussions] Calculated Column for DIF
I need to create a calculated column using the DATEDIF. The problem comes from if the item is completed before the due date it creates a negative number. This is fine except that Sharepoint view the negative number as an error. #NUM!. How can I create the calculated column to show me the negative numbers. I use these to track metrics to see if we are ahead of schedule.
Current formula being used is =DATEDIF(Due,[AF],"D")
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
[Non-text portions of this message have been removed]
From: sharepointdiscussio
Sent: Monday, August 20, 2012 6:43 PM
To: sharepointdiscussio
Subject: [sharepointdiscussi
I need to create a calculated column using the DATEDIF. The problem comes from if the item is completed before the due date it creates a negative number. This is fine except that Sharepoint view the negative number as an error. #NUM!. How can I create the calculated column to show me the negative numbers. I use these to track metrics to see if we are ahead of schedule.
Current formula being used is =DATEDIF(Due,
------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
[Non-text portions of this message have been removed]
Tue Aug 21, 2012 11:01 am (PDT) . Posted by:
"Catherine Isbell" catisbell01
You are my hero. Thank you for your time and knowledge.
On Tue, Aug 21, 2012 at 8:37 AM, Cheetham, Phillip <
phillip.cheetham@cityofboston.gov > wrote:
> **
>
>
> This works in Excel:
> =IF(MIN(Due,[AF])=Due,DATEDIF(Due,[AF],"D"),-(DATEDIF([AF],Due,"D")))
>
> From: sharepointdiscussions@yahoogroups.com [mailto:
> sharepointdiscussions@yahoogroups.com ] On Behalf Of catisbell01
> Sent: Monday, August 20, 2012 6:43 PM
> To: sharepointdiscussions@yahoogroups.com
> Subject: [sharepointdiscussions] Calculated Column for DIF
>
>
> I need to create a calculated column using the DATEDIF. The problem comes
> from if the item is completed before the due date it creates a negative
> number. This is fine except that Sharepoint view the negative number as an
> error. #NUM!. How can I create the calculated column to show me the
> negative numbers. I use these to track metrics to see if we are ahead of
> schedule.
>
> Current formula being used is =DATEDIF(Due,[AF],"D")
>
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
>
> [Non-text portions of this message have been removed]
>
>
>
--
Catherine Isbell
[Non-text portions of this message have been removed]
On Tue, Aug 21, 2012 at 8:37 AM, Cheetham, Phillip <
phillip.cheetham@
> **
>
>
> This works in Excel:
> =IF(MIN(Due,
>
> From: sharepointdiscussio
> sharepointdiscussio
> Sent: Monday, August 20, 2012 6:43 PM
> To: sharepointdiscussio
> Subject: [sharepointdiscussi
>
>
> I need to create a calculated column using the DATEDIF. The problem comes
> from if the item is completed before the due date it creates a negative
> number. This is fine except that Sharepoint view the negative number as an
> error. #NUM!. How can I create the calculated column to show me the
> negative numbers. I use these to track metrics to see if we are ahead of
> schedule.
>
> Current formula being used is =DATEDIF(Due,
>
> ------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
>
> [Non-text portions of this message have been removed]
>
>
>
--
Catherine Isbell
[Non-text portions of this message have been removed]
Tue Aug 21, 2012 6:12 am (PDT) . Posted by:
"deanl1440" deanl1440
It all depends on what kind of work you are doing. I don't see any problem with adding Content (text and images directly to production) for pages such as announcments and news articles. Adding new web parts created by devs in Visual Studio should definetly be done in a dev/test environment. Depending on the number of people involved with creating content you may or may not want to implement the Content Approval process. It also depends on who the audience is, are you publishing to the public internet or an internal site? You also need to consider the ramifications of a publishing mistake, will a typo or wrong image be a big deal, if so, you need a formal review process.
--- In sharepointdiscussions@yahoogroups.com , "kakthom410" <ken.thompson@...> wrote:
>
> Our webmaster is frustrated with the SP 2010 OOB deployment process for moving our publishing site content changes from a Dev box to a Stage box and finally to the production box. In other words, he is not pleased with how long it takes for a change made on page X on the development instance of our public site to actually being able to see it in production.
>
> He feels that the overall process (even using Quick deploy) is actually cumbersome and unnecessary in our particular environment. He would like to be able to manage content changes directly in the production system.
>
> It seems to me from what I have seen and read regarding working directly on a production system is risky.
>
> Can anyone help me communicate the risks for Sr. management and / or if I am wrong and it is no big deal to do this kind of work directly on a production box, please let me know that too. Maybe I need to back off? Thanks for any counsel you can give and / or experiences you may have had with a similar situation!
>
> Ken
>
--- In sharepointdiscussio
>
> Our webmaster is frustrated with the SP 2010 OOB deployment process for moving our publishing site content changes from a Dev box to a Stage box and finally to the production box. In other words, he is not pleased with how long it takes for a change made on page X on the development instance of our public site to actually being able to see it in production.
>
> He feels that the overall process (even using Quick deploy) is actually cumbersome and unnecessary in our particular environment. He would like to be able to manage content changes directly in the production system.
>
> It seems to me from what I have seen and read regarding working directly on a production system is risky.
>
> Can anyone help me communicate the risks for Sr. management and / or if I am wrong and it is no big deal to do this kind of work directly on a production box, please let me know that too. Maybe I need to back off? Thanks for any counsel you can give and / or experiences you may have had with a similar situation!
>
> Ken
>
GROUP FOOTER MESSAGE
Moderated by Mindsharp, www.mindsharp.com > Know More. Do More.
