-
Count+Distinct
=COUNT(DISTINCT(CHILDREN())) I using the formula above to count the distinct number of bays for different shipments, some shipments would have all of the bays in one cell. Is there a way to modify this formula to count the bays within one cell separately? (for clarification the example above would be 3 distinct bays while…
-
Pulling information based on dropdown selection
I'm pulling information from 1 sheet into another to be used as a dashboard reference and i'm having trouble with a formula.. I need to collect names if "awarded" is selected in a separate column's drop-down. Is there a way to do this?
-
AND(OR Statement Help
I'm getting stuck on this one. I have a working OR statement formula based on no information from two different columns. I want to add a third variable based on another column having a specific statement. I've tried this a few ways but, nothing has worked. Working Original statement: =IF(OR([ePRG Training]@row <> "",…
-
Getting multiple Fields from 1 row using MAX and COLLECT
I have a sheet (IDF Check) that contains static information about my IDF's that I want to use as a kind of dashboard. I have a second sheet (IDF Checklist) that collects information from weekly checks on the IDF including Date and time checked, the inspectors name and a calculated field of the overall status of the IDF.…
-
Looking for a formula to create a unique key
I'm looking for a formula such as MD5 to create a unique key where one does not exist naturally in the worksheet data. When combining two or more columns a unique value is possible, but it would be great to have an formula to calculate a representative vale.
-
countif help
Hi Folks hoping i can get some assistance I have a large tracker that is tracker COVID isolations and test results. i have made a "Summary" sheet that is designed to create a value to display defined information on a dashboard I made a Weeknumber helper column, the week number will generate if - Positive is checked and…
-
Two new PPM Functions: Successors and isCritical, available now!
Hi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task and return a collection of values that will occur as a result of the referenced task.…
-
Issue with Index Collect Formula
Looking for help! We collect form responses that load onto this sheet below the KPI section. I need to see, at a glance, TODAY'S responses in the Reporting Data section. So I'm using an INDEX COLLECT formula to pull in today's response from each team member. However, I am getting the errors as shown below. I simply want to…
-
How can I convert text names to existing contacts in my account?
I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed the column on my sheet to 'Contacts' thinking I'd be able to leverage contacts in my…
-
Formula to count a value within a given range
I am trying to write a formula that must meet (2) criteria and then count the number of values that are: <500 =500 and <=999 ( this is the formula I cannot write for some reason) >999 I have been successful at pulling the two criteria but cannot figure out how to add the count in the formula. I set them up and can pull the…