Koen360 - profile

Koen360 · Aug 21, 2024

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

Koen360 · Jun 10, 2024

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

Koen360 · Aug 21, 2024

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

Koen360 · Jun 10, 2024

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

Koen360 · Feb 08, 2024

Any updates on this? Much wanted, much requested, quick fix. C'mon Airtbale

User Statistics

User Activity

Rollup field formula combined with Logical operators

Find the maximum of three date fields including time stamp

Re: Rollup field formula combined with Logical operators

Re: Find the maximum of three date fields including time stamp

Re: Folders in Workspaces