Is there a way to create a rule to dynamically activate when additional columns enter the table if they have a specific suffix? for example:
My table has columns of Data and then math done on that data so if say i have Col1 i will also have Col1_math. Can i make conditional formatting apply dynamically when col2, col3, etc. enter my table with their respective _math columns?
I want to make a dynamic column rule that checks if the column name has _math then apply conditional formatting to the data in that column. I've tried clicking on dynamic or unknown columns and creating a rule on [_current field_] but it's not working. I can't manually adjust each time as columns change depending on who's running the data for which information they want.
Really stuck here.
Edit: attached spreadsheet with the problem. I have say 3 col and 3 calcs that i know of to do conditional formatting on. However, there are 3 more cols and maths to be done in the future. How can I get Alteryx to dynamically add conditional formatting to the calc columns only if they are dynamically added?
