-
Count if formula to include multiple years
Hello, I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024? Current equation:…
-
Sumifs That Excludes Parents
Hello, I am working on an ever expanding project timeline that has 100's of parent tasks that flow into potentially up to 10+ levels of parent tasks, with children tasks at every level. Given the granularity of the task management and the timeline being outwardly facing, "=sum(children())" is used on every parent task to…
-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
-
Help with WEEKNUMBER formula
Hi, I need a column to show the week number of the year. When I try the simple =weeknumber(TimeCardEntryDate@row) formula, it doesn't seem correct, but I've seen other posts about how Smartsheet calculates week numbers uniquely. I need the weeks to count from Sunday-Saturday. So, in the picture below, 12/31/23-1/6/24…
-
How to replace an SOP in a row when that row is updated
Hi everyone! I am creating an SOP Tracking system for my company where I will track all SOP’s being created. That being said, I need to be able to replace an SOP when the SOP is updated. Can I do this using either forms or automation? The SOP will have a specific name associated with it that will be able to be matched when…
-
Why is this formula #invalid operation
=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], >1 / 1 / 2023, [Date of Award]:[Date of Award], <3 / 30 / 2023) If I put the dates in parenthesizes it yeilds 0 even though I have "FSC" in the Flight column. If I take them away it becomes #invalid.
-
Help with CountIFs formula
Hello, I am trying to use the CountIFs formula to calculate the number of times each category in a drop down list appears in one column. I'd also like to be able to make sure the items are only being counted are in Hierarchy level 2. Below is the list of categories, can anyone please help me understand writing the formula?…
-
Formula that counts # of incidents across a date range
I have a sheet for all incidents in the company that was started in 2023 and now that we're in 2024 I need to update some formulas so it only pulls the data for the current year. Right now the formula is =COUNTIFS({Incident Type}, [Primary Column]@row) but this doesn't take the date range into consideration. What should…
-
Using Formula for a total count/sum
Thank you for taking my question. What is the format to create a formula that supports this scenario; A total count or sum based on a specific word in a cell in a sheet. For example, collect the total number of the word "Pass". Same for "Fail" and so on.
-
Creating a formula to calculate percent from the parent rows
I am trying to create a formula for a cell where it collects the percentage of all the % values in the parent rows below it. Not only the current parent rows, but also any new ones that are added. The parent rows are currently averaging the percent in the sub rows below it. In this case, I want the total percent to be in…