Forum Discussion
Solved
How can I combine multiple row values into 1
Newbie here. I have a table that has an ApptStatus column. Among others, there are 3 that start with "Cancelled....". Cancelled by Client Cancelled By Vendor Cancelled Due To Technical Issues...
Hi,
"Use the Switch young Jedi". Joke aside, create a new column as follows:
New Status = SWITCH( TRUE(), Table[ApptStatus] = "Cancelled by Client", "All Cancellations", Table[ApptStatus] = "Cancelled by Vendor", "All Cancellations", Table[ApptStatus] = "Cancelled Due To Technical Issues", "All Cancellations", Table[ApptStatus])If this answered your question, please mark it as the solution.
Ashish_Mathur
Super User
Super UserHi,
Write this calculated column formula
Column = if(containsstrng(Data[AppStatus],"Cancelled"),"All cancellations",blank())
Hope this helps.