-
IF statement for a check box helper column
I have a form that has a status of sick or returning. There are other columns but not needed for the formula (other than name). I want to add a helper checkbox and when someone submits a form for returning (they will have already submitted one for sick) the matching "sick" row and the new returning row will match the name…
-
Trying to count values based on variables
Hi there - first question ever! Also - not great at using the right language so sorry if it's a bit confusing! I am currently trying to use a formula to count if a certain condition is met in column a - and in column b - to count it. so for example Column A (Role) Manager Assistant Officer Column B (Off Work) Yes No Yes So…
-
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…