-
Countif on Formula Column
Can someone tell me what I'm doing wrong? I want to count all entries in a column that say 'Exceeds'. The formula I have in place is this: =COUNTIF([Q4 Performance]:[Q4 Performance], "Exceeds") The answer it is returning is the '#Invalid Operation' error. The only thing I can think of is that the entries in [Q4…
-
Checkbox - adding rec'd inventory to 'In Stock number' when un checking box
I need help to add back order inventory to In stock field when the check box is 'unchecked'. In other words, when we finally receive our back order supply list I would like the sheet to automatically add the Order size number to the In stock field number. The purple are in back order.
-
Helper columns
Hi there, Is there a tutorial on helper columns? Helper columns have been suggested to me, and I'm sure they will help our group but I am still confused on how to use them. Thank you! Esperanza
-
Counting and Averaging with Exclusions
Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the divisional sheet-level and the metrics sheet-level. Problem 1) Sheet Summary…
-
COUNTIFS - Cross-sheet references, AND, DATE formula
I am trying to count the times a plant has entered on a specific date. (We have 14 plants - so...) I want to know how many times Birmingham entered data on 9/1/20. I can count BHM data entries;I can count the number of entries on 9/1. But I can't seem to put it together. =COUNTIF({Plant}, "Birmingham")…
-
HH:MM sum formula in Smartsheet
I have a series of times that our staff spend on a particular activity for a month in format HH:MM as shown below but I'm struggling with how to create a formula in smartsheet that allows me to sum these values are report the result in the format HH:MM too? Can anyone assist?
-
I need to lookup a column on one sheet and reference a column and value on another sheet.
I have a Model# on sheet 1. I need to search for the same Model# on sheet 2 and if found, look at that Model's status and return that value to sheet 1. Caveat: the Model Status on sheet 2 is a drop down list (Complete, Not Complete), so I need whatever value is selected to pull into sheet 1. I tried a VLOOKUP using the…
-
COUNTIFS #INVALID REF appear after a period of time
Hello, Able to get the countifs to total up some information in a different sheet. But then after a period of time, some of the cells using the countifs display #INVALID REF when it worked when I created my sheet screen shot shows a portion of my sheet, all cells use countifs and all cells did count what I wanted it too.…
-
Formula that returns true/false if today's date falls between two dates on my sheet?
I am trying to write a formula that returns true/false when today's date falls between a date range on my sheet. I want the formula to return "true" if today's date falls between "Start Date" and "End Date." Below is my current formula, but I continue get a returned value of "#DATE EXPECTED." =IF(AND(TODAY() >= [Start…
-
Formula to count how many people will be in the office specific day(s)
I have 2 sheets and I'm trying to populate how many people will be in the office on specific days. One sheet has the specific date(s) and where the sum value should be and i need to gather from another sheet who is coming in on the specific days. I tried formulas but kept getting an error.