Conectare
 
Pagina de pornireBibliotecăInformațiiFişiere de descărcatSuportComunitateForumuri
Resurse pentru profesionişti IT >
> 
> 
Can I use the SPD Formula (Fx) to populate a column?

Answered Can I use the SPD Formula (Fx) to populate a column?

  • 1 mai 2012 16:53
     
     
    Sign in pentru a vota
    0

    I have 3 choice columns with the following options, (Yes, NR, Signed In) and I want a 4th column to populate with "Complete" OR "Not Complete" depending on the values of the 3 choice columns. I want to create a column that can be used to Group/Filter.

    I have tried using a Caculated column but can't seem to get it to work so is it possible to accomplish this with the formula feature in SPD?

    If all 3 choice columns have "Yes" OR "NR" then Complete, otherwise Not Complete.

    I can create a formula but not sure how/if its possible to then populate the 4th column.

     ( $thisNode/@CY_x0020_T4 = 'Yes' or $thisNode/@CY_x0020_T4 = 'NR' )  and  ( $thisNode/@CY_x0020_T5 = 'Yes' or $thisNode/@CY_x0020_T5 = 'NR' )  and  ( $thisNode/@CY_x0020_Other = 'Yes' or $thisNode/@CY_x0020_Other = 'NR' )

    Stunpals - Disclaimer: This posting is provided "AS IS" with no warranties.

     

Toate mesajele

  • 1 mai 2012 17:42
     
     
    Sign in pentru a vota
    0

    Hi

    have you tried to use lookup column ?

    Romeo Donca, Orange Romania (MCSE, MCTS, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

     
  • 1 mai 2012 18:18
     
     Răspuns
    Sign in pentru a vota
    0

    Not clear what you mean romeo?
    But interested in other options.

    I have found a long solution to this issue.

    I need a Calc column StatusCounter that will use the following formula.

    • =IF([CY T4]="Yes",1,0)+IF([CY T5]="Yes",1,0)+IF([CY Other]="Yes",1,0)+IF([CY T4]="NR",1,0)+IF([CY T5]="NR",1,0)+IF([CY Other]="NR",1,0)

    Then I can use another Cacl column (CY Status) to set the Complete/Not Complete by using a =IF([StatusCntr] = 3, "Complete","Not Complete").

    Stunpals - Disclaimer: This posting is provided "AS IS" with no warranties.


     
  • 1 mai 2012 18:37
     
     Răspuns
    Sign in pentru a vota
    0
    You should be able to do this with the calculated column, and it looks like you have a formula that works. Thats probably the best option. You can also do everything you want in XSLT with sorting/grouping but it requires being savvy with SPD and XSLT.

    Please mark my response as an answer if appropriate.
    Learn.SharePoint.com