Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Question on Conditional Column as Parameter

I am working on a skillset survey, and the rating is know of, beginner, intermediate, advanced and expert, and I have used a conditional column to assign values 1, 2, 3, 4, and 5. I would like to kee...
Need Help
Tutorial Requests
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

“so I would like my definition set in my conditional column to include all coloumns,”

I don't particularly understand your needs, could you show me a sample data model and describe your needs in detail.

 

Best Regards,
Lionel Chen

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for your replies 🙂

     

    This is my data as I have been sorting it in Excel. I am working on creating graph example and it is important that rating is not changed to a numerical value. So I have created a conditional column to assign numerical value to the text, but my question whether I would need to create a conditional column for each column in my spreadsheet, or is there someway smarter to do it?