About djbginns

djbginns · 11-27-2023

Hi, could someone help me fix an iFS condition that checks for a conflict of exact dates and times.do i need to combine the two to make it match? IFS( OR( ISBLANK([Event Start Date]), ISBLANK([Event End Date]), ISBLANK([Event Start Time]), ISBLANK([E...

djbginns · 07-13-2023

Hi Guys, @dbaum , @Suvrutt_Gurjar , @WillowMobileSys , @Steve I am having difficulty creating a filter slice for a task manager. I am trying to create a filter that matches the Company, then the Department, then the Employee. Employee = employee user...

djbginns · 07-01-2023

Hi, I keep getting an error trying to run a task bot from a chat slice command. It keeps saying "Unable to find the column" This is the current setup. Please let me know if anyone has a solution. Task Name <<[Task Name]>>Task Status: <<[Task Status]>...

djbginns · 06-16-2023

Hi, I am looking for a formula to custom sort / group by a category, the order is custom and does not fit the criteria of an alphabetical order. I have been trying to figure out a Sort or order by , but can't seem to get to the bottom of it. "Sort Or...

djbginns · 05-08-2023

Hi Guys, I need help setting up a dereference from these two tables. My Challenge is that the category column is already a reference to another table ( Category Types). I created the table Expense Category Database to store Category Types and am tryi...

djbginns · 11-28-2023

I figured it out, combined the rows as a CONCATENATE and ran this formula. IF(OR(ISBLANK([Event Start Date and Time]),ISBLANK([Event End Date and Time])),"Invalid Submission",IF(ISNOTBLANK(FILTER("Form Responses 1",AND([Event Start Date and Time] < [...

djbginns · 11-28-2023

I got this expression to work for the start and end dates conflicting, but not the times. I also don't think a count is the best means of finding the solution. IF(OR(ISBLANK([Event Start Date]),ISBLANK([Event End Date]),ISBLANK([Event Start Time]),IS...

djbginns · 06-16-2023

I came up with a temporary solution using dashboard view! but it be a helpful way to sort if you did not have to create a slice for all the categories and could sort in one view. Maybe the google team could consider it for future developments.

djbginns · 06-16-2023

Hi Suvrutt, thank you for your quick response. I am looking for a method to actually display it in a UX card view and not in a PDF unfortunately. I was wondering if there could be a way to use CONCATENATE() Function to combine a key order that is eas...

djbginns · 06-07-2023

Have you attempted to add any additional conditions to this expression ? for example if the item was logged today and is of a certain category class ? let me know.Thanks!

My Stats

djbginns's Bio

Badges djbginns Earned

Recent Activity

Finding Two Submissions that Overlap With Start and End Dates and Start and End Times

Advanced Filter Company and Then Department

Unable to find column in automation using a data slice.

custom grouping categories in card view

Using Look Up and Select To Input An Initial Value

Re: Finding Two Submissions that Overlap With Start and End Dates and Start and End Times

Re: Finding Two Submissions that Overlap With Start and End Dates and Start and End Times

Re: custom grouping categories in card view

Re: custom grouping categories in card view

Re: Format Highlight Todays Logged Items