locked
How to make a column equal one of many possibilities based on text in another column. RRS feed

  • Question

  • Basically I want to do this. If Column 1 = "Text" (The "Text" is going to be selected from a dropdown that may have 10 items for that column), THEN Column 2 = Result (Result will be one or more items that will show in the result column).

    Example:

    If Column 1 Text = Daily, Then Column 2 = Trash Cans and Windows, BUT If Column 1 Text = Monthly, Then Column 2 = Wash Dishes BUT If Column 1 = Yearly, Then Column 2 = Vacuum Carpet

    This should be so simple, But I cannot figure it out. I know I will be using a calculated column.

    Thanks

     

     

    Friday, October 7, 2011 2:22 PM

Answers

  • Hi,

     

    You can try the following formulas in column 2:

     

    =IF([Column 1]="Daily", "Trash Cans and Windows", IF([Column 1]="Monthly", "Wash Dishes", IF([Column 1]="Yearly", "Vacuum Carpet", "Please enter daily, Monthly or Yearly")))

     

    Hope this helps.

     

    Thanks,

    Pengyu Zhao

    • Marked as answer by Wayne Fan Friday, October 14, 2011 2:07 AM
    Monday, October 10, 2011 3:22 AM
  • HI,

    This can be done using calculated columns.

    Create a formula for the same and apply to your column.


    Thanks, Rahul Rashu
    • Marked as answer by Wayne Fan Friday, October 14, 2011 2:07 AM
    Monday, October 10, 2011 3:31 AM

All replies

  • Hi,

     

    You can try the following formulas in column 2:

     

    =IF([Column 1]="Daily", "Trash Cans and Windows", IF([Column 1]="Monthly", "Wash Dishes", IF([Column 1]="Yearly", "Vacuum Carpet", "Please enter daily, Monthly or Yearly")))

     

    Hope this helps.

     

    Thanks,

    Pengyu Zhao

    • Marked as answer by Wayne Fan Friday, October 14, 2011 2:07 AM
    Monday, October 10, 2011 3:22 AM
  • HI,

    This can be done using calculated columns.

    Create a formula for the same and apply to your column.


    Thanks, Rahul Rashu
    • Marked as answer by Wayne Fan Friday, October 14, 2011 2:07 AM
    Monday, October 10, 2011 3:31 AM