-
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!
-
Workaround to override column formula for dates?
Hi there, I have a sheet with 8,000 rows. In the sheet, each row has a task, task start date and task end date. When someone adds a start date to the first task, the rest of the dates are calculated with a formula, based on a lookup table that has values for how long each task takes. If I have 10 tasks, I want the formula…
-
Is there a Way to Emulate SUMPRODUCT In Smartsheet With a Cross Sheet Reference?
Hi all! I am trying to create a SUMPRODUCT in Smartsheet, however when I do I receive the "INVALID OPERATION" error. This is how I was trying to go about it; I created a helper column where I would multiply both A x B, then I was simply going to sum up all the products. The issue I'm encountering is with the first part. I…
-
Countifs to Find Duplicates
I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it. =COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55'…
-
Formula Help
Hi, I have this formula that pulls from the values below (see screenshot) but the formula says #NO MATCH when no stage is started, then again once all stages are complete. Can someone help me with a formula that will give another value other than #NO MATCH. It should say "New Project" before the stages start and "Project…
-
Give same value to parents, children, and grandchildren
How can I make parents, children, and grandchildren show the same value for "Project Name" regardless of hierarchy level? I am importing some of the information in the sheet from the database and the children/grandchildren are subtasks that need to be labelled with the project name. The solutions I have tried so far have…