Sean_Lake1 - profile

Sean_Lake1 · May 16, 2023

Good day all. I have some records where an attendee fills out a form and selects multiple events. This form populates several things:Calendar Table(which also generates GCal events)Junction TableAttendee's table with all the courses(Array)I want to...

Sean_Lake1 · May 04, 2023

Good day all.I have a formula that currently works:IF({Course Status}='Retired',"RET-"&CONCATENATE(LEFT({Course Level},1),{Course Type Coding (from Course Type)},".",{Sequence Number})&"-"&{Course Name},CONCATENATE(LEFT({Course Level},1),{Course Type...

Sean_Lake1 · May 02, 2023

Hey all!I've got a long formula, that currently has just one IF statement, however, I need to update to add another alternate IF.Here is the existing formula, that works:IF({Course Status}='Retired',"RET-"&CONCATENATE(LEFT({Course Level},1),{Course T...

Sean_Lake1 · May 02, 2023

Hey All!I'm sure I'm overlooking a tiny detail, but here goes.My existing formula is:DATETIME_FORMAT({Date and Time},'MM-DD-YY h:mm a')&" GMT"&" - "&{Course Name}The documentation shows to add a timezone, to do this:DATETIME_FORMAT(SET_TIMEZONE("07/1...

Sean_Lake1 · Feb 09, 2023

Good day all!Currently we schedule training that has been nicely integrated with GCal. Recently, we decided to track rescheduled training for better communication and reporting. I've added a "RESCHEDULED" check box to be marked when a training has ...

Sean_Lake1 · May 22, 2023

Hey there MLO!Ok, I've already made another junction table:and manually placed two "attendee's" info into them to get an idea of how I want to the data to appear:So this table will store/track the attendee to the class. So that we can see a one to o...

Sean_Lake1 · May 17, 2023

Yes, does seem to be a simple question, but I'm not seeing what I'd think would be right for my case, either:For my issue, I have #invited, #who showed up, and calculation of %showed up. Simple math but apparently, not the case LOL.

Sean_Lake1 · May 16, 2023

I finally got it. AT support(Sean K), and I worked on it, but when we logged off, I hadn't noticed that the FULL field was opened and it'd duplicated the course id 2x. EEK!No worries, I worked it out:SWITCH({Course Status},"Retired","RET-"&CONCATENA...

Sean_Lake1 · May 16, 2023

Hum, Kuovonne, that didn't work for me, and since it's not a lookup field, rollups won't workI have a text field, with pasted in emails, all separated by a comma, the field is "Who Showed up?" The formula field is "#Who Showed Up:COUNTALL(ARRAYUNIQUE...

Sean_Lake1 · May 08, 2023

Your first solution, worked, however the bottom one wiped out all the data! No worries, ctrl-z fixed it fast! Thanks!

User Statistics

User Activity

Extract values from field [Array,Array,Array]

If and If nested statements

Updating formula - Nested IF statements

Formula - adding time zone, not working??

Setting up a tracker for dates

Re: Extract values from field [Array,Array,Array]

Re: Calculate Percentage using Total From Column

Re: If and If nested statements

Re: Count unique text (names) separated by commas in another formula field (arrayunique)

Re: If and If nested statements