Deric ✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	16

About Me

About Me

Industry	Government

Analytics

50

Posts

257

Visits

714

Points

Mar 10, 2023

Join Date

May 1, 2024

Last Active

Reactions

• Insightful 2

  2
• Vote Up 4

  4
• Awesome 2

  2

• Activity
• Discussions1
• Comments49

• Re: Joining two data sets using a multiselect column

  Deric

  02/28/24
  This is what i came up with: =JOIN(DISTINCT(COLLECT({Data_AttendeeDepartment}, {Data_AttendeeName}, HAS([Attendee names]@row, @cell))), CHAR(10))
  1 ·

• Re: Dynamic Formula for remaining value based on date

  Deric

  05/19/23
  @ShannonL This should work: =IF(MONTH(TODAY()) < 4, [Total Planned Billing]@row, IF(MONTH(TODAY()) < 7, [Total Planned Billing]@row - [23q1]@row, IF(MONTH(TODAY()) < 10, [Total Planned Billi…
  1 ·