-
Out of office Calendar
Hi, I would like to build a sheet to collect inputs from my team across the regions to share to the entire team the planned “out of office” period. These could be half day (morning or afternoon) or full day. I plan to use a FORM to manage the input entries but I’m looking for a way to display well the scheduled…
-
The Average Number of Monthly Projects
I want to be able to have a formula that pulls the average number of projects we complete monthly for our sheet summary. I have a date column for "Date Completed". Can anyone help with what the formula would look like?
-
Sequential Unique identifier for two types of records in a sheet
Hello Smartsheet community. I am in need of a solution that allows me to leverage an intake form to track Objectives and Key Results. I need to be able to sequentially generate unique ID's for each Objective and for each KR and I need this to not break with sorting. The reason is, I need to do lookups on the Unique…
-
=SUMIF Formula
I'm looking for some guidance with this formula. I can't seem to get the numbers to add up if the condition is met. Essentially if the cell is "No" a number should be added and the number is different based on the column. Those numbers should then be added for a total. Here's what I'm working with... =SUMIF([Column]1 =…
-
#INCORRECT ARGUMENT SET in Nested IF statement
Hey All, I think I have all my ducks in a row here, but I continue to get a #INCORRECT ARGUMENT SET Error. Trying to dynamically set a status indicator. Can someone assist? For more info: [Assigned To] is a Contact List [Resolved] is a checkbox =IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 0), "In Progress",…
-
Contains formula not picking up text
Hi, I have this contains formula that searches for M&E and im not sure why its not working. Could someone please point me to where im going wrong. Thanks, Liam
-
COUNTIFS on multiple columns looking for multiple conditions.
Hi, Im trying to count how many rows fit a specific criteria. Here is my example table: In this example I want to count how many rows are assigned to "In House" with a Status of "In" and Difficulty of "A". This is my formula: =COUNTIFS([Assigned To]:[Assigned To], "In House", [Status]:[Status],…
-
Using COUNTIFS for multiple criteria
I wanted to count the number of TASKS that have a STATUS <> Complete where the FINISH date is <= TODAY and I have that formula: =COUNTIFS(Status:Status, <>"Complete", Finish:Finish, <=TODAY()) Now I want to add Assigned To into this equation. So I want to count the number of TASKS that have a STATUS <> Complete where the…
-
COUNTIF - FINDING MULTIPLE VALUES IN 2 COLUMNS
I am trying to write a formula that will count 2 values in one column & exclude two values in another column. My two columns are: Department & Modified. I want to count the words "Sale" and "Manager" in this multi-select column but only if the Modified column doesn't contain "Furlough" or "Separated". I tried:…
-
Building a Sum If Statement
I'm trying to build a SumIfs statement that calculates the number of hours by type (Sick, Vacation, Personal) by employee ID. I'm able to do a simple SimIf for the total, but struggling with how to break it down by sick type. This is the statement I'm using and its resulting in an incorrect argument: =SUMIFS({Employe…