-
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…
-
INDEXM() function to pull nth value from a multiselect dropdown.
After posting a laundry list of what I believe are simple ideas that I thought had already been requested, it was suggested that I post them individually on this idea board. While I think this idea is out there, I am unable to find it. My apologies if this is a repeat: Function to pull Nth value from a multiselect field.…
-
COUNTIFS formula not calculating correctly in 3 of 4 columns- I'm at a loss
What is wrong with my formula? I need it to return the number of times it finds a certain answer from a drop down list for a specific facility between 2 dates. The dates we are searching are from the first of the current month through yesterday. Ex. if it's March 13, 2024, I'm looking for data between March 1, 2024-March…
