-
COUNTIFS Based on RYG with Multiple Criteria
A colleague and I are trying to create a sheet summary that counts each of "Red", "Yellow", and "Green" statuses. The formula we've tried to use for this is as follows: =COUNTIFS(DMA:DMA, "St. Louis, MO", [2020 Reimage]:[2020 Reimage], "Y", [Ext. Paint]:[Ext. Paint], "Green") However it returns either a #NO MATCH. The…
-
Counting previous months data
Hi, i am looking for some help please. I have been reporting using today and looking back 30 days, however my business now wants me to report on the previous months data. so if in Mid June it looks at May's data Is this possible to have as a formula? Thank you Dave
-
help to run holidays for all our staff
Hi all I need some help, im trying to use smart sheet to run holidays for all our staff. I have a main source sheet for all the staff where all the calculations are taking place. i then have separate department sheets running with booking forms. I want to introduce a booking pin to avoid spamming. This would have a file…
-
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…