-
How to not show "O" results
So I used the formula below to count the courses in my helper field Course Count. I don't want to see the "zeros" in fields that are empty. So, how do I fix that? =COUNTIF(Courses@row, HAS(@cell, "Wound")) + COUNTIF(Courses@row, HAS(@cell, "ostomy")) + COUNTIF(Courses@row, HAS(@cell, "continence"))
-
Index/Match using two criterias
I'm trying to see if I can use index/match with two criteria's. First criteria being the name, and the second the month. So far I am using this: What would be the best way to match Operator Name & Month? I am referencing another sheet that has Name & Month as well, followed by the summary. This seems to be the formula!…
-
COUNTIFs if Column contains multiple values
Hi all, I have a Form that users submit when an Error is detected made throughout the business. As part of this, they select what department(s) make the error. Which inputs multiple values into the cell. e.g. Artworks, Production etc. I'm trying to count the number of errors per department using a CountIF formula. (I also…
-
How to count 'blank' cells in a column.
Hello, I am trying to count the blank cells in a column and i'm using the ISBLANK formula. however it keeps saying INCORRECT ARGUMENT. the formula works with every other status in the column in my reference sheet but doesn' count the blanks. Please help! this is the formula im using: =ISBLANK({TEMPO TRADE WORK TRACKING…
-
Nested If statemens
I've read various posts on the forum and have been able to fix a few of my issues but I can't seem to get past this one. To show the stage of a project is in a workflow, I am using various IF(AND(NOT(ISBLANK, meaning that stage has been completed. So, if the Outreach stage is complete, it will not be blank, etc. In my AND…
-
Availability Formula
I/m actually using this formula to check the current week availability of the employees considering all the jobs' dates of the year in which they are involved: =IF(AND(WEEKNUMBER([Start Date]3:[Start Date]11) = WEEKNUMBER(TODAY()), WEEKNUMBER([End Date]3:[End Date]11) = WEEKNUMBER(TODAY())), "not available", "available")…
-
Incorrect Argument Set
Please help: why am I getting this "Incorrect Argument Set" =SUMIFS([Targeted Area]:[Targeted Area], "Atopic Dermatitis", [Approved 2022 $$]:[Approved 2022 $$], 1) This formula uses 2 columns [Targeted Area] and [Approved 2022 $$] (which has the $$ approved amount) and says... look at the "Targeted Area" column, if it is…
-
Project Settings Timeline Display for Gantt Chart : mm/ss
Has a solution been created yet to display a Gantt chart in minutes and seconds and to reduce the unit of time for start and finish to minutes and seconds. I would love to create a mfg process flow in smartsheets, but the current unit of time does not permit that.
-
If formula for recurring date based on date value of another cell
Hi everyone! I would like a formula to automatically update a date column every 3 years based on another Date column E.g. If reference cell is 1-SEP-2022 then I want the next Date column cell to automatically change to 1-SEP-2025, then to 1-SEP-2028, and so on… Does anyone know if this is possible? Thank you,
-
FORMULA(S) ERRORS
I have been trying to "MATCH/NO MATCH" values in sheet A with Sheet B. first by columns to ensure data integrity then to do a formula that will return MATCH/NO MATCH if all criteria is met, with an "@cell " formula to match =IF(COUNTIFS({PAYEE}, FIND(Payee@row, @cell) = 1, {DATE}, FIND([Invoice Date]@row, @cell) = 1, {INV…