Skip to main content

Hello Again!

So I have a SharePoint list with a Nintex Workflow.  In one of those columns is data from a multiple checkbox option for branches.  Is there a way to parse that data and create a new column in said list that shows the branches so when it is exported to Excel it can be sorted by the branch even when it might have more than one branch?

Thanks,

Carrie.

I'm just curious why you are exporting to Excel?


Roger,

They want to analyze the data for something lol.

Carrie.


Is there a reason they cannot analyze it directly in SP? These are questions I always like to ask because sometimes the user doesn't realize the full capability of SharePoint. They often think of it as a glorified file share.


Some folks just like to take the data offline and analyze and do other things outside of the list. They know it isn't a glorified file share wink.png


Sorry, didn't mean to imply that yours did! Just speaking in general.

I suppose you could create a calculated column for each branch, and if your choice columns contains the branch populate the individual branch field with the branch name.


Reply