I have a table with one field for start date and one field for end date. These dates are looked up from another table. I want to have a field that shows a concatenate of the two.
Here is what I have:
CONCATENATE({Estimated Start Date},"-",{Estimated ...
I removed the grouping, then sorted by in home dates and then re grouped by customer which gave me the result I was looking for.
Hopefully this continues to work as I add to the table!
Thanks for your assistance!
Kamille_Parks:
SWITCH({Multiple Select Field Name}, ‘Designer A’, ‘URL A’, ‘Designer B’, ‘URL B’, ‘Designer C’, ‘URL C’, …)
That worked! Thanks a bunch! I was not doing the correct punctuation. So thankful for knowledgeable and generous people...
