I'm looking to see if something is possible with SS.
We have internal teams that request our support for their clients. Depending on the client support level, there are different options available. Our solution was to have 2 different forms for the same sheet so we can track everything in one place. The top 50 clients have their own request form and to validate, they have to select the client from a drop down. Otherwise if their client is NOT on that drop down, they have to use the standard form and can input ANY client name.
for our tracking and dashboards, we need all the client names in one column but I'm stuck as to how to achieve this. i was using the following formula but if I put it in the "client name" column, then if there is already a name there, it changes it to blank.
=IF(ISBLANK([Top 50 Client Name]@row ), "", [Top 50 Client Name]@row )
My 2 ideas to achieve this are PURPLE: have a formula that moves the top 50 client name into the "client name" column but if there is nothing in the top 50, nothing happens and the client name stays.
or in RED, somehow combine the 2 cells and have a 3rd helper column that gives us the end result. One of the columns will always be blank there would never be a scenario where both have text so essentially the helper column would be our ACTUAL client list.
Perhaps there is another way I am not considering. I did try automations and did not see how to achieve this either. Thanks!
