Trending in Formulas and Functions
-
Formula Help! Adding Values in child rows based on date range
I'm trying to add the values entered in all child rows in a column, based on the date range (by quarter): =SUMIFS(CHILDREN([PT Total Hours]@row ), CHILDREN(Date@row ), ">=01/01/2025", CHILDREN(Date@row ), "<=03/31/2025") This is what the AI formula came back with, also what another external AI platform came back with.…
-
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
-
Character Limit Formula
I'm unable to convert this to column formula (probably due to the reference to my 'blank' column… However, this formula doesn't work, =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID Limited to 20 VARCHAR", "") So, I changed it to this, which works… =IF(LEN([Source Admission ID]) >= 21, "Source Admission ID…
