-
#INCORRECT ARGUMENT SET error
Good afternoon, I have been getting #INCORRECT ARGUMENT SET error when using this formula: =IF(AND(Category@row = "Demo account"; [Custumised timeframe]@row = "No"); Submission@row + 30; ""; IF(Category@row = "Content contributor"; [Estimated Editing end date]@row; IF(AND(Category@row = "External supplier"; [Custumised…
-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
-
IF(OR) formula - add AND qualifier for all
I have an IF(OR) formula that is working exactly the way I want it to. I want it to check a box if one of three column criteria is met, which it is doing correctly, using the below formula: =IF(OR([Column A]@row = "Choice1", [Column B]@row = "Choice2", [Column C]@row = 1)), 1 I want to add a second condition that applies…
-
Formula for drop-down menu selections
=IF(CONTAINS([202-Disability,801- Offender,802 Low income,803ESL]@row, "Disability"), 1, 9) What changes need to be made to the above formula to return a "1" if "Disability" is selected, and a "9" if it is not selected--whether or not there are multiple selections made in the drop-down menu? This formula works when…
-
Conditional formatting, status balls don't change colour
Hi! I'm using this nested-if formula to automatically update the status ball: =IF([% Complete]@row < "70%"; "Red"; IF(AND([% Complete]@row >= "70%"; [% Complete]@row < "100%"); "Yellow"; IF([% Complete]@row = "100%"; "Green"))) The status ball, however, stays red for all rows, what am I doing wrong? The sheet can read the…
-
How to use IF formula using 2 different columns?
I have a Status column and I want the Status column to be updated based on the updates on 2 different columns. If Resolution Date column has any value, mark status column as “Complete” If Due Date column date is today’s date or less and there’s nothing in the Resolution Date column, mark status column as “Delayed” If Due…
-
COUNTIFS Error when using IFERROR
Hello, I am trying to use the COUNTIFS formula in a sheet where I need the formula to count all cells with the value matching the Claim Status value, within the month and year stated in the next column, but the formula keeps breaking when i add in the Claim Status as a condition to look for. Does anyone know how this can…
-
This is my first Q post so if I don't provide enough info, let me know.
I have 7 categories of "open" tickets to resolve a software issue. The project name is "SCRM". I am trying to use the COUNTIFS formula to tell me how many open tickets I have against SCRM if an open ticket counts if the criteria is one of the seven categories. This is what I started with and I can't get past the first…
-
In need of a formula to count number of occurrences based on date
I have a Date & Location column in one sheet and on another sheet I have a date and cell that needs to sum the number of times a location appears on that date. What formula can I use to achieve this? Sheet A Sheet B End goal for example: Rochester cell = 2 Albany cell = 2
-
Today's Date Formula
Hello! Is there a formula I can use in Smart sheet that will give me Today's date? Ideally I want to have the cell change to whatever "today's" date is in order to create a separate formula that calculates days until a certain deadline. Thank you!
