kingsleyspencer - profile

kingsleyspencer · Jun 05, 2023

In our scheduling table for projects (table is called "Deliverables"), we have 6 sequential dates that tend to move frequently:Kickoff DateCreative ConnectRound 1 to ClientRound 2 to ClientRound X to ClientDue DateI've been trying to write a formula ...

kingsleyspencer · Jun 29, 2023

@Stephen_Orr1 Here's where I landed: IF( OR({Kickoff Date}, {Creative Connect Date}, {R1 to Client Date}, {R2 to Client Date}, {RX to Client Date}, {Mech/Finalize Date}, {Due Date}), DATETIME_PARSE( MIN( IF(IS_AFTER({Kickoff Date}, TODA...

kingsleyspencer · Jun 05, 2023

I generally agree, but our projects have clear start and end dates, but the milestones in-between those dates move and shift around a lot. They're generally more important to know for our production teams though thus the trying to make this "Next Due...

kingsleyspencer · Jun 05, 2023

I've seen a lot of rollup + min(values) but the dates are stored in 6 columns (per record). The Rollup only requests a single field and we need to look at all 6 dates—unless I just really really don't understand the Rollup field type.That's been my m...

kingsleyspencer · Jun 05, 2023

Might have gotten closer with this:IF( OR({Kickoff Date}, {Creative Connect}, {Round 1 to Client}, {Round 2 to Client}, {Round X to Client}, {Due Date}), MIN( IF(IS_AFTER({Kickoff Date}, TODAY()), {Kickoff Date}), IF(IS_AFTER({Crea...

User Statistics

User Activity

Formula to find next upcoming date from 6 other date columns in a record

Re: Formula to find next upcoming date from 6 other date columns in a record

Re: Formula to find next upcoming date from 6 other date columns in a record

Re: Formula to find next upcoming date from 6 other date columns in a record

Re: Formula to find next upcoming date from 6 other date columns in a record