Hello, relatively new to Alteryx and wanted to know if it was possible to dynamically fill rows with data? I have a spreadsheet (attached) and I want to assign senior managers to staff. As it is right now, if a staff has anything other than an actual client (e.g. apple, google, microsoft) in the engagement name, like vacation, then a senior manager won't be assigned to them. I would like to fill the SM column for rows that say vacation with the senior managers that the staff are assigned to.
I know it's hard to understand via writing, so I attached an example of my current state and my desired state in the spreadsheet. Please let me know if you can help!
