Sharepoint Question

[timwhit]

I'm trying to do something in Sharepoint that I thought would be pretty simple, but it turned out to be a huge waste of time. Maybe someone here has enough experience to say whether what I'm trying to do is possible or not.

I want to add a calculated column to a list that captures the date under a couple conditions. The calculated column is called Resolve Date.

1. If the column Status equals "Resolved"
2. If the column Resolve Date is blank

This means that Resolve Date must reference itself, which I think is impossible in Sharepoint.

I thought something along these lines would work:

=IF((ISBLANK([Resolve Date])),IF([Status]="Resolved",TEXT([Modified],"MM/DD/YYYY"),""),[Resolve Date])

I also tried to create another calculated column and populate that with Resolve Date, and then reference that column in my Resolve Date but that also resulted in the same problem.

Does anyone know if this is possible some other way?

 

[Mercutio]

I asked the person I work with who does sharepoint stuff, and she couldn't think of a way to make it work eithre.

Sorry.

 

[timwhit]

I asked the person I work with who does sharepoint stuff, and she couldn't think of a way to make it work eithre.

Sorry.

Thanks for trying.

In conclusion, Sharepoint is a piece of shit.

 

[ddrueding]

In conclusion, Sharepoint is a piece of shit.

We could have just started there, but I thought it would have been mean.

 

[Mercutio]

There is nothing and I do mean nothing like the murderous rage I have for Outlook. Sharepoint is a perfect product in comparison.