Trying to set a claculated field based on two other fields

SharePoint calculated field

I have three columns

field1
field2
field3

I want field 3 to = complete if field1 and field2 are complete, otherwise the field should = initial

is that doable?
Matt PinkstonAsked:
Who is Participating?
 
Keyboard CowboyConnect With a Mentor Commented:
Field 3 (type Text) calculated should be =IF(AND(Field1="Complete",Field2="Complete"),"Complete","Initial") - worked on my test site.

There's a terrific SharePoint calc'ed columns cheat sheet at http://www.pentalogic.net/sharepoint-knowledge-base/calculated-column-cheat-sheet  you have to register to download but free and you can any email address you have access to - I just use the one I use for shopping and doing this kind of thing which I never really check really.  Cheers
1
 
Keyboard CowboyCommented:
Question answered with example code
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.