-
Updating Status column based on two different columns
I am looking for a way to have a column state "Cancelled", Submitted, or "Completed" based on two different columns in Smartsheet. If SAP1 column = "No" I want the "Status" column to say "Cancelled". If SAP1 is "Yes" and another column that states who completed the request is filled in with any name (is not blank), then I…
-
Alternate way of pulling Countifs with WEEKNUMBER functions
Hi, I have a weekly report that needs to count all the leads per lead source and my source sheet is pulling the data from google sheets. To count the report automatically from the sheet source, I am using this formula below. [Select week] column dictates the week number that I need. As you I have heard, WEEKNUMBER pulls…
-
What is wrong with this =AVERAGEIF formula
Here is my formula - =AVERAGEIF({Week Number}, ={Current Week}, {Daily Cnt Comp}) Where Week number is a cross reference to Audit Report column Week number Current week is a cross reference to the Audit Report SS to the current week number based off the current date I cross reference the {Daily Cnt Comp} column in the…
-
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…