6 New Messages
Digest #4507
| |
Messages
Wed Aug 22, 2012 6:04 am (PDT) . Posted by:
"Catherine Isbell" catisbell01
Do you have time for one more question. Everything was going along fine
until this last entry.
This one works
=IF(MIN([Due Date],Supplier)=[Due Date],DATEDIF([Due
Date],Supplier,"D"),-(DATEDIF(Supplier,[Due Date],"D")))
This one does not
=IF(MIN([Due Date],Approved)=[Due Date],DATEDIF([Due
Date],Approved,"D"),-(DATEDIF(Approved,[Due Date],"D")))
If I take and copy the top one into the calculation it works. If I go back
in and change the Supplier for Approved then I get the #NUM! Error again.
It will calculate positive numbers. I do not get a syntax error. I cannot
figure out what the difference is.
On Tue, Aug 21, 2012 at 10:38 AM, Catherine Isbell <isbellcm01@gmail.com >wrote:
> 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
>
--
Catherine Isbell
[Non-text portions of this message have been removed]
until this last entry.
This one works
=IF(MIN([Due Date],Supplier)
Date],Supplier,
This one does not
=IF(MIN([Due Date],Approved)
Date],Approved,
If I take and copy the top one into the calculation it works. If I go back
in and change the Supplier for Approved then I get the #NUM! Error again.
It will calculate positive numbers. I do not get a syntax error. I cannot
figure out what the difference is.
On Tue, Aug 21, 2012 at 10:38 AM, Catherine Isbell <isbellcm01@gmail.
> You are my hero. Thank you for your time and knowledge.
>
>
> 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
>
--
Catherine Isbell
[Non-text portions of this message have been removed]
Wed Aug 22, 2012 6:04 am (PDT) . Posted by:
"Catherine Isbell" catisbell01
Never mind I found the error. It was the fact that one of the columns it
was calculating from was done as Text and not Date.
Thanks again for your help.
On Tue, Aug 21, 2012 at 2:05 PM, Catherine Isbell <isbellcm01@gmail.com >wrote:
> Do you have time for one more question. Everything was going along fine
> until this last entry.
>
> This one works
> =IF(MIN([Due Date],Supplier)=[Due Date],DATEDIF([Due
> Date],Supplier,"D"),-(DATEDIF(Supplier,[Due Date],"D")))
>
> This one does not
> =IF(MIN([Due Date],Approved)=[Due Date],DATEDIF([Due
> Date],Approved,"D"),-(DATEDIF(Approved,[Due Date],"D")))
>
> If I take and copy the top one into the calculation it works. If I go
> back in and change the Supplier for Approved then I get the #NUM! Error
> again. It will calculate positive numbers. I do not get a syntax error.
> I cannot figure out what the difference is.
>
> On Tue, Aug 21, 2012 at 10:38 AM, Catherine Isbell <isbellcm01@gmail.com >wrote:
>
>> 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
>>
>
>
>
> --
> Catherine Isbell
>
--
Catherine Isbell
[Non-text portions of this message have been removed]
was calculating from was done as Text and not Date.
Thanks again for your help.
On Tue, Aug 21, 2012 at 2:05 PM, Catherine Isbell <isbellcm01@gmail.
> Do you have time for one more question. Everything was going along fine
> until this last entry.
>
> This one works
> =IF(MIN([Due Date],Supplier)
> Date],Supplier,
>
> This one does not
> =IF(MIN([Due Date],Approved)
> Date],Approved,
>
> If I take and copy the top one into the calculation it works. If I go
> back in and change the Supplier for Approved then I get the #NUM! Error
> again. It will calculate positive numbers. I do not get a syntax error.
> I cannot figure out what the difference is.
>
> On Tue, Aug 21, 2012 at 10:38 AM, Catherine Isbell <isbellcm01@gmail.
>
>> You are my hero. Thank you for your time and knowledge.
>>
>>
>> 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
>>
>
>
>
> --
> Catherine Isbell
>
--
Catherine Isbell
[Non-text portions of this message have been removed]
Wed Aug 22, 2012 8:09 am (PDT) . Posted by:
"Peter Brunone" peter_brunone
I have a client who has virtualized their MOSS environment in order to test
the impact of SP2 (yes, it is that far behind).
Obviously they don't want to take the production box offline, so I'm having
to get creative on their behalf. They've installed SQL Server on the local
VM and put all the SP database backups there, so the farm can exist on the
one virtual server. I've run the config wizard, told it to disconnect, and
then run again and told it to connect to the farm on the local machine, and
said yes, host the CA website here.
After all that, though, my request for Central Admin still redirects me to
the production box. Also, the portal site collection throws a "Cannot
connect to the config database" error (it seems to be using a different
domain account, and when I try to change the default DB server, I get an
unknown error).
The "Servers in Farm" list still shows the production box as a member of
this particular farm. I have a feeling that some of the problems would be
easy to fix if I could remove it, but I'm a little leery of doing so on the
off chance that it could mess up the production environment.
Any suggestions?
TIA,
Peter
[Non-text portions of this message have been removed]
the impact of SP2 (yes, it is that far behind).
Obviously they don't want to take the production box offline, so I'm having
to get creative on their behalf. They've installed SQL Server on the local
VM and put all the SP database backups there, so the farm can exist on the
one virtual server. I've run the config wizard, told it to disconnect, and
then run again and told it to connect to the farm on the local machine, and
said yes, host the CA website here.
After all that, though, my request for Central Admin still redirects me to
the production box. Also, the portal site collection throws a "Cannot
connect to the config database" error (it seems to be using a different
domain account, and when I try to change the default DB server, I get an
unknown error).
The "Servers in Farm" list still shows the production box as a member of
this particular farm. I have a feeling that some of the problems would be
easy to fix if I could remove it, but I'm a little leery of doing so on the
off chance that it could mess up the production environment.
Any suggestions?
TIA,
Peter
[Non-text portions of this message have been removed]
Wed Aug 22, 2012 8:43 am (PDT) . Posted by:
"Tieland, Steve" stieland
I would setup a SQL Alias on the box (production db name - now pointing to local db). Once that is confirmed, then you can check and change other settings as you will not be hitting the current production db.
Central Admin - you might have to change the alternate access mapping.
Steve
From: sharepointdiscussions@yahoogroups.com [mailto:sharepointdiscussions@yahoogroups.com ] On Behalf Of Peter Brunone
Sent: Wednesday, August 22, 2012 11:10 AM
To: sharepointdiscussions@yahoogroups.com
Subject: [sharepointdiscussions] Virtualization of SP2007
I have a client who has virtualized their MOSS environment in order to test
the impact of SP2 (yes, it is that far behind).
Obviously they don't want to take the production box offline, so I'm having
to get creative on their behalf. They've installed SQL Server on the local
VM and put all the SP database backups there, so the farm can exist on the
one virtual server. I've run the config wizard, told it to disconnect, and
then run again and told it to connect to the farm on the local machine, and
said yes, host the CA website here.
After all that, though, my request for Central Admin still redirects me to
the production box. Also, the portal site collection throws a "Cannot
connect to the config database" error (it seems to be using a different
domain account, and when I try to change the default DB server, I get an
unknown error).
The "Servers in Farm" list still shows the production box as a member of
this particular farm. I have a feeling that some of the problems would be
easy to fix if I could remove it, but I'm a little leery of doing so on the
off chance that it could mess up the production environment.
Any suggestions?
TIA,
Peter
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Central Admin - you might have to change the alternate access mapping.
Steve
From: sharepointdiscussio
Sent: Wednesday, August 22, 2012 11:10 AM
To: sharepointdiscussio
Subject: [sharepointdiscussi
I have a client who has virtualized their MOSS environment in order to test
the impact of SP2 (yes, it is that far behind).
Obviously they don't want to take the production box offline, so I'm having
to get creative on their behalf. They've installed SQL Server on the local
VM and put all the SP database backups there, so the farm can exist on the
one virtual server. I've run the config wizard, told it to disconnect, and
then run again and told it to connect to the farm on the local machine, and
said yes, host the CA website here.
After all that, though, my request for Central Admin still redirects me to
the production box. Also, the portal site collection throws a "Cannot
connect to the config database" error (it seems to be using a different
domain account, and when I try to change the default DB server, I get an
unknown error).
The "Servers in Farm" list still shows the production box as a member of
this particular farm. I have a feeling that some of the problems would be
easy to fix if I could remove it, but I'm a little leery of doing so on the
off chance that it could mess up the production environment.
Any suggestions?
TIA,
Peter
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Wed Aug 22, 2012 8:44 am (PDT) . Posted by:
"Peter Brunone" peter_brunone
Thanks, Steve. One problem, though: how do I change AAM if I can't get to
CA?
On Wed, Aug 22, 2012 at 10:24 AM, Tieland, Steve
<stieland@oldmutualus.com >wrote:
> I would setup a SQL Alias on the box (production db name - now pointing to
> local db). Once that is confirmed, then you can check and change other
> settings as you will not be hitting the current production db.
>
> Central Admin - you might have to change the alternate access mapping.
>
>
> Steve
>
> From: sharepointdiscussions@yahoogroups.com [mailto:
> sharepointdiscussions@yahoogroups.com ] On Behalf Of Peter Brunone
> Sent: Wednesday, August 22, 2012 11:10 AM
> To: sharepointdiscussions@yahoogroups.com
> Subject: [sharepointdiscussions] Virtualization of SP2007
>
>
>
> I have a client who has virtualized their MOSS environment in order to test
> the impact of SP2 (yes, it is that far behind).
>
> Obviously they don't want to take the production box offline, so I'm having
> to get creative on their behalf. They've installed SQL Server on the local
> VM and put all the SP database backups there, so the farm can exist on the
> one virtual server. I've run the config wizard, told it to disconnect, and
> then run again and told it to connect to the farm on the local machine, and
> said yes, host the CA website here.
>
> After all that, though, my request for Central Admin still redirects me to
> the production box. Also, the portal site collection throws a "Cannot
> connect to the config database" error (it seems to be using a different
> domain account, and when I try to change the default DB server, I get an
> unknown error).
>
> The "Servers in Farm" list still shows the production box as a member of
> this particular farm. I have a feeling that some of the problems would be
> easy to fix if I could remove it, but I'm a little leery of doing so on the
> off chance that it could mess up the production environment.
>
> Any suggestions?
>
> TIA,
>
> Peter
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Moderated by Mindsharp, www.mindsharp.com > Know More. Do More.Yahoo!
> Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
CA?
On Wed, Aug 22, 2012 at 10:24 AM, Tieland, Steve
<stieland@oldmutualu
> I would setup a SQL Alias on the box (production db name - now pointing to
> local db). Once that is confirmed, then you can check and change other
> settings as you will not be hitting the current production db.
>
> Central Admin - you might have to change the alternate access mapping.
>
>
> Steve
>
> From: sharepointdiscussio
> sharepointdiscussio
> Sent: Wednesday, August 22, 2012 11:10 AM
> To: sharepointdiscussio
> Subject: [sharepointdiscussi
>
>
>
> I have a client who has virtualized their MOSS environment in order to test
> the impact of SP2 (yes, it is that far behind).
>
> Obviously they don't want to take the production box offline, so I'm having
> to get creative on their behalf. They've installed SQL Server on the local
> VM and put all the SP database backups there, so the farm can exist on the
> one virtual server. I've run the config wizard, told it to disconnect, and
> then run again and told it to connect to the farm on the local machine, and
> said yes, host the CA website here.
>
> After all that, though, my request for Central Admin still redirects me to
> the production box. Also, the portal site collection throws a "Cannot
> connect to the config database" error (it seems to be using a different
> domain account, and when I try to change the default DB server, I get an
> unknown error).
>
> The "Servers in Farm" list still shows the production box as a member of
> this particular farm. I have a feeling that some of the problems would be
> easy to fix if I could remove it, but I'm a little leery of doing so on the
> off chance that it could mess up the production environment.
>
> Any suggestions?
>
> TIA,
>
> Peter
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------
>
> Moderated by Mindsharp, www.mindsharp.
> Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
Wed Aug 22, 2012 10:50 am (PDT) . Posted by:
"Tieland, Steve" stieland
I think that should be fine once the SQL alias is in place. You may need to run through the product and config wizard again and have it set the CA to the current single server.
Steve
From: sharepointdiscussions@yahoogroups.com [mailto:sharepointdiscussions@yahoogroups.com ] On Behalf Of Peter Brunone
Sent: Wednesday, August 22, 2012 11:44 AM
To: sharepointdiscussions@yahoogroups.com
Subject: Re: [sharepointdiscussions] Virtualization of SP2007
Thanks, Steve. One problem, though: how do I change AAM if I can't get to
CA?
On Wed, Aug 22, 2012 at 10:24 AM, Tieland, Steve
<stieland@oldmutualus.com <mailto:stieland%40oldmutualus.com>>wrote:
> I would setup a SQL Alias on the box (production db name - now pointing to
> local db). Once that is confirmed, then you can check and change other
> settings as you will not be hitting the current production db.
>
> Central Admin - you might have to change the alternate access mapping.
>
>
> Steve
>
> From: sharepointdiscussions@yahoogroups.com <mailto:sharepointdiscussions%40yahoogroups.com> [mailto:
> sharepointdiscussions@yahoogroups.com <mailto:sharepointdiscussions%40yahoogroups.com>] On Behalf Of Peter Brunone
> Sent: Wednesday, August 22, 2012 11:10 AM
> To: sharepointdiscussions@yahoogroups.com <mailto:sharepointdiscussions%40yahoogroups.com>
> Subject: [sharepointdiscussions] Virtualization of SP2007
>
>
>
> I have a client who has virtualized their MOSS environment in order to test
> the impact of SP2 (yes, it is that far behind).
>
> Obviously they don't want to take the production box offline, so I'm having
> to get creative on their behalf. They've installed SQL Server on the local
> VM and put all the SP database backups there, so the farm can exist on the
> one virtual server. I've run the config wizard, told it to disconnect, and
> then run again and told it to connect to the farm on the local machine, and
> said yes, host the CA website here.
>
> After all that, though, my request for Central Admin still redirects me to
> the production box. Also, the portal site collection throws a "Cannot
> connect to the config database" error (it seems to be using a different
> domain account, and when I try to change the default DB server, I get an
> unknown error).
>
> The "Servers in Farm" list still shows the production box as a member of
> this particular farm. I have a feeling that some of the problems would be
> easy to fix if I could remove it, but I'm a little leery of doing so on the
> off chance that it could mess up the production environment.
>
> Any suggestions?
>
> TIA,
>
> Peter
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Moderated by Mindsharp, www.mindsharp.com<http://www.mindsharp.com > > Know More. Do More.Yahoo!
> Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Steve
From: sharepointdiscussio
Sent: Wednesday, August 22, 2012 11:44 AM
To: sharepointdiscussio
Subject: Re: [sharepointdiscussi
Thanks, Steve. One problem, though: how do I change AAM if I can't get to
CA?
On Wed, Aug 22, 2012 at 10:24 AM, Tieland, Steve
<stieland@oldmutualu
> I would setup a SQL Alias on the box (production db name - now pointing to
> local db). Once that is confirmed, then you can check and change other
> settings as you will not be hitting the current production db.
>
> Central Admin - you might have to change the alternate access mapping.
>
>
> Steve
>
> From: sharepointdiscussio
> sharepointdiscussio
> Sent: Wednesday, August 22, 2012 11:10 AM
> To: sharepointdiscussio
> Subject: [sharepointdiscussi
>
>
>
> I have a client who has virtualized their MOSS environment in order to test
> the impact of SP2 (yes, it is that far behind).
>
> Obviously they don't want to take the production box offline, so I'm having
> to get creative on their behalf. They've installed SQL Server on the local
> VM and put all the SP database backups there, so the farm can exist on the
> one virtual server. I've run the config wizard, told it to disconnect, and
> then run again and told it to connect to the farm on the local machine, and
> said yes, host the CA website here.
>
> After all that, though, my request for Central Admin still redirects me to
> the production box. Also, the portal site collection throws a "Cannot
> connect to the config database" error (it seems to be using a different
> domain account, and when I try to change the default DB server, I get an
> unknown error).
>
> The "Servers in Farm" list still shows the production box as a member of
> this particular farm. I have a feeling that some of the problems would be
> easy to fix if I could remove it, but I'm a little leery of doing so on the
> off chance that it could mess up the production environment.
>
> Any suggestions?
>
> TIA,
>
> Peter
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------
>
> Moderated by Mindsharp, www.mindsharp.
> Groups Links
>
>
>
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
GROUP FOOTER MESSAGE
Moderated by Mindsharp, www.mindsharp.com > Know More. Do More.
No comments:
Post a Comment