Katelynn_Straw1 - profile

Katelynn_Straw1 · Feb 20, 2020

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 ...

Katelynn_Straw1 · Feb 10, 2020

I am trying to link a few different drop box URL’s to our table. The case use would be if designer X is selected from the multi select drop down, return URL(A), if designer XX is selected, return URL(B), if designer XXX is selected, return URL© and ...

Katelynn_Straw1 · Mar 04, 2020

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!

Katelynn_Straw1 · Mar 01, 2020

I’m trying to sort by date as pictured below and it’s clearly not working. What am I doing wrong? The numbers don’t change whether I do 1-9 or 9-1…

Katelynn_Straw1 · Feb 20, 2020

Thank you both!! I have never used & and wasn’t sure where exactly to put the DATE_FORMAT on my concatenate.

Katelynn_Straw1 · Feb 10, 2020

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...

Katelynn_Straw1 · Feb 10, 2020

So ‘URL A’ is the actual URL? And it works as a URL?

User Statistics

User Activity

How do I concatenate two date fields?

Can I use IF or SWITCH to return different URL's?

Re: Is there a way to sort chronologically?

Re: Is there a way to sort chronologically?

Re: How do I concatenate two date fields?

Re: Can I use IF or SWITCH to return different URL's?

Re: Can I use IF or SWITCH to return different URL's?