Hi everybody,Let's say I've got 2 tables linked to one another (NUMBERS and OBJECTS)Table 1: 100 NUMBERS ranked from 1-100Table 2: OBJECTS which are randomly linked to these NUMBERS OBJECT A is linked with 6 random NUMBERS: 5, 6, 7, 11, 12, 13In OBJE...
I found this formula in the community. However I want to include a timestamp aswell. Since {date 1}, {date 2}, {date 3} may occur on the same day. I tried adding a format specifier but it wont work... The formula sets the time to a default 12:00am in...
Hi @Pascal_Gallais- Your approach is quite clever. However working with text fields instead of numeric fields leads to a new problem. It only works when the NUMBERS are linked in the right order. For instance if OBJECT A is linked like this: 7, 11, 5...
Well... that was easier then I thought. Here's the answer for future ppl who may struggle.I used the wrong format specifier... I wanted to have a DD-MM-YYYY LT format. But that doesn't work with the MAX()-function I suppose. It worked by adding the l...
