This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’ve got dates from two different columns being drawn into a main column that I need to be able to filter and sort.
To get the data into the main column I cobbled together different formulae from this forum, however when I try to format the column it...
Hi Justin,
Thank you for your help with this. That was the original formula I started with but it wasn’t allowing me to format as a date.
I have now traced back the other columns that it’s linked too and realised that a formula in one of the tables ...
Hi Justin,
Thank you for your help with this and making the formula much cleaner.
With your formula i’m getting the same end result which is great, but I still can’t format the column as a date. The main reason I want to format as a date is so I can ...
Hi John, thank you for getting back to me so quickly.
As a company we have clients on either of two different types of contracts - therefore we’ve got a table for each of these with their contract details. What we’ve then got is another ‘master’ tabl...
