-
I am in need of a formula that will count the number of entries in one column like below.
I would like a column formula to auto populate column two "Total number of entries in left column" does anyone have a suggestion on how I can do this?
-
Mode of Column (text)
Hello, I have seen that Smartsheet does not have a mode function similar to Excel, but I would love some help in figuring out a workaround. I have read other posts about workarounds, but have not had any luck getting it to work. I currently have a lot of 5-point Likert survey data (across 60 "parent" surveys) and I want to…
-
Formula to only count unique cells, no duplicates
Hello again, is there an =countifs formula that can be used to only count unique cells which would avoid counting duplicate cells in that column? below i want to count W01-W06 only once for the answer to be 6 instead of counting all the duplicate W01 to =8 thanks!
-
Row copying over twice
Hello :) Our Metric Archiver tracks the number of units we recieve, wash, process, etc. daily. The last 2 years we have only been dealing with towable units. We recently brought in motorized units, so I updated colums to reflect towable and added columns to reflect motorized. Here is a screenshot of that sheet. This sheet…
-
Display name based on maximum value
I have a field of Patrollers, they are using a form to enter interactions with customers. In my sheet I have been able to create a summary report that counts the various Interactions by Patroller breaking out (Guest Assist, Violation, Slow Zone), cant get the sheet to Sort my count... But what I am looking for, and it…
-
Multiple IF(AND criteria with NETWORKDAYS?
I am trying to use NETWORKDAYS with two criteria: whether there was a value in [PO Issues] + whether or not it was checked/addressed in [PO Issue Resolved]. My current formula is: =IFERROR(IF(AND([PO Issue Resolved]@row = "false", ([PO Issues]@row <> "", NETWORKDAYS([Quality Control End Date]@row, [Receiving Completed…
-
is this possible? - form fill, populate time, then multiple sheets update based on time
We are trying to automate some contractor time submissions. Can we: bi-weekly time sheet - create form that; form pulls drop down contractor name from separate sheet (contractor pay rate). Contractor enters job name from drop down option, enters hours for the week, enters email address and uploads sign off form. can 2…
-
Why am I get an error when I added IFERROR to formula:
=IFERROR(YEAR([Current Charleys GO]@row) - YEAR([Walmart Revised GO date from 7/8]@row)) * 12 + IFERROR(MONTH([Current Charleys GO]@row) - MONTH([Walmart Revised GO date from 7/8]@row)), "")
-
Invalid Data Type when Date column empty
Hi all, I'm using the formula below to calculate the NETWORKDAYS between the date an invoice was submitted until it is paid, if it has not been paid it calculates the NETWORKDAYS with TODAY. The formula is working, however, I'm getting an error on every row that does not have a date sent for payment yet. Is there a way to…
-
Counting Completed Tasks For Dashboard Report
On the project metrics sheet used for dashboard reporting, I need to count the number of times a particular task has been marked as completed using a checkbox. Here is a screenshot of what I am trying to count (see green highlight). Here is what this looks like on the project metrics sheet including the formula that keeps…