-
Find the earliest outstanding date with parameters
Hi all, I am trying to create a formula, that finds the earliest date in {Date Received}, if the {Date Processed} is blank. I have tried this formula, but it comes back as #Invalid Column Value: =(MIN(COLLECT({Date Received}, {Date Processed}, ""))) I then added an IFERROR as below, but that returns no value at all.…
-
Automated Form Submission Location ID
Is there a way to automatically collect the location (Lat/Long) of the device submitting a form? I like the ability within the Smartsheet App to add a location, but unfortunately it can be moved prior to submitting. Any ideas?
-
Countifs And/Ors
I am trying to count a specific series: Region1 + StatusComplete + Month series =COUNTIFS({Central HUB – 2019 Range 1}, [Primary Column]@row, {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-01")), {Central HUB – 2019 Range 3}, AND(OR(@cell = "2020-02"))) Formula only works with 1 Month, once I add the second month, it…
-
Does not equal "<>" does not return when looking at a number
I want to sum the Range "Students" IF the cell does not equal "/". The formula does not work when the criterion cell is equal to any number. Can anyone help work around this Current Formula: =SUMIF([21_03]34:[21_03]42, <>"/", $Notes34:$Notes42)
-
VLOOKUP - NO MATCH
Could you hrelp me to short out this problem? I want to copy the "NAC ID" in a cell using Vlookup formula. But I always get "NO MATCH". Data collected from a form: Used Formula: "Affected units" is a dropdown column with multiple selection.
-
If with AND (add an OR?)
Hi! Current formula below is in a separate column labeled Attestation? but is resulting in blocked. Really, the second criteria and third criteria should be if HRSA is either OLCP or OCS. What am I doing wrong? IF(AND([Worker Type]:[Worker Type] = "Contingent Worker", [HRSA]:[HRSA] = "OLCP", [HRSA]:[HRSA] = "OCS"), "Yes",…
-
Help w/NOT counting specific agreements in a COUNTIFS formula
Hi team - I have a requirement to do a COUNTIFS formula that looks across a pretty large sheet (almost 4000 rows) and sum up those "agreements" that have errors. Currently I'm using this formula (this is for the month of May, I change the month number for other month counts): =COUNTIFS({Agreements out for Approval (C H M)…
-
excel translation
=+AVERAGE(SUMPRODUCT(F$13:F$19,$D$13:$D$19)/SUM($D$13:$D$19),F20,F21)
-
Difficulties Using ISBLANK Function
Hello, I am curious what I need I need to do, am relatively new to SS and it's functions. We review products, and often times this analysis requires the product to be sent out to a third-party for analysis. I do not want these third-party days (business days only) counted against the lab's time to complete. What formula do…
-
Count Unique Values based on another value
Hi all, Is it possible to count unique values from two separate columns in one formula? In the attached photo I am trying to count the amount of unique "AssociationName" for each unique "CompanyName"? Basically, I want to know how many AssociationName's for each CompanyName. Does that make sense? Thank you!!!