I need the formula to display the duplicate values found in a rollup.
I can’t do ArrayUnique because I actually want to know what the duplicate ones are and there are too many combinations for me to code it using an if statement for each result.
Than...
I have an automation that is running into issues all a sudden.
I have a linked field that needs to accept two record IDs into the linked field.
I have tried adding the 2nd one if the first is already there, which then deletes the first.
I have also t...
I have a formula that is taking a Start Date Field with value 9/10/2022 2:30pm GMT
I am trying to get the time of the event in 24 hour format using DATETIME_FORMAT({Start Date},“HH:MM”)
The result is coming up 21 minutes short and giving me 14:09 vs....
I have a very predictable set of data across multiple tables.
There is one table where a person can request a room for a meeting.
If the room for the meeting is more than 30 minutes I run automation to make sure the next 30 minutes time period is ass...
My timeslots has links to each event and I can lookup the people in each one.
So my timeslot table has the rollup of all people in all rooms during that time. I need to look in that rollup to find the duplicates
Ok I here is the best I can do:
I have a table of timeTable of peopleTable of locationsI have people scheduled to an time in a locationI want to see if any one person is booked to more than one location in any given time and raise a red flag
