-
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…
-
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…