-
Formula =COUNTIFS ... to not include certain text
ok almighty people..... I currently have =COUNTIFS({Depots1}, [Column1]23, {Product1}, FIND("Other", @cell) > 0) This counts cells that depot is = column 1 row 23, if the product column contains the word Other (product column a multiple select cell, with free type option) However I want to count cells that depot is =…
-
Course Delivery Date formula
I have a formula that seems simple, but for some reason it's calculating an extra day. There are three columns and the first is duration in days, the next is delivery date, then the third is the end date. What should be happening is the delivery date should be counted as one day, then the calculations should be added to…
-
COUNTIF functions returning 0
I am trying to create a countif formula that references one other sheet. I want it to pull with 2 different criteria if the column = 01 and the second column = "open". =COUNTIFS({Dump: OPEN AND CLOSED REQS Range 1}, "01", {Dump: OPEN AND CLOSED REQS Range 2}, "Open"). This function returns 0 when I know there is a few that…
-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Formula to collect column names if there is a "1" present
I have a pivot table that I am attempting to use in order to collect a list of all jobs that our subcontractors have/are working on. Basically, I want a roll up of all jobs that each sub has worked on. The sheets where this info is held are all on individual sheets, which is the reason I used a pivot table to try and get…
-
Update % COMPLETE based on another column
I have an IF() that I am running to calculate a % complete of a tasklist. I want the % COMPLETE column to have the same value, so it will shade the bar in the gantt view. How do I do that? I changed the settings for the "% complete column" to none to allow me to input a formula. However, it did not shade the bar (guessing…
-
Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
-
Net Promoter Score Calculation
Hi all, I'm stumped on a formula (again!) I'm looking to ascertain a NPS and I've got the following going on: Promoters: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How likely are you to recommend NCR to a colleague], ">=9") Detractors: =COUNTIF([How likely are you to recommend NCR to a colleague]:[How…
-
Formula that pulls data from specific columns in a successor row
I found the row ID (not a column but the row id created by smartsheet) of the successor rows using the successor column. I'm struggling to figure out how to reference the smartsheet row id in a formula in order to pull data for the successor row for a specific column. The use case is a helper column that will show the…
-
Automation to move rows stopped working
I have an automation setup to move a row to another sheet when the status us changed to "Complete". This automation was working fine until I upgraded from Business to Enterprise. Now the automation does not trigger automatically, and when I trigger it manually it moves all rows from the source sheet to the destination…