-
Child Parent Formula Help
I want my formula to look at the child count column and if it is great than one to run a sum of the children rows and if it has 0 children to run a lookup SUMIFS formula: I was hoping it would work like this but I keep getting errors. =IF([Children Count]@row > 0, SUM(Children()), SUMIFS({Curo.Points}, {Curo.Category},…
-
Update Request Form
I have a scenario where marketing managers update a sheet based on the activity they are doing. We then copy the row, via workflow, to another sheet which then triggers an update request for them to supply additional information via the update request form. The problem is that we cannot edit or modify the update request…
-
SUMIFS forumula
Hi, I am trying to write a formula which counts from another sheet but keep getting incorrect argument. =SUMIFS({Project Type}, "Event Coverage", {Project Status}, "Complete", {Month Identifier}, "January", {Year Identifier}, "2024")
-
Calculating Previous X Weeks at the New Year Turnover
Hello, I've got this handy formula calculating if a row record is from the previous 5-weeks that worked great up until the new year. Now I need something to know that Week 1-2023 and Weeks 49-52-2022 are what should be considered. It's probably not as hard as I'm making it out to be and I'm sure someone has run into this…
-
I need Help with a function
Im currently in the proccess of switching from excel to smart sheets i need a formula that will change the color of a cell based on #days before a start date of a project. essentially if a task is not completed like a dumpster isnt ordered and the project starts in 3 days the cell turns red. Im guessing the excel function…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
Change formula to only count network days
Hi All, This formula works great to count the days which return a figure greater than 1 in a specific month / year. However I wish to remove the figures counted on weekends. I know I need to alter this to a network day formula but currently struggling to do so. Any help would be much appreciated. =COUNTIFS({REGISTER DATE},…
-
Formula for sheet summary field to count dates in column
Hello, Can someone help direct me to the right formula for counting the number of dates entered in one column where selected criteria in a second column applies? I tried this but can't get it to work when I add the AND CONTAINS to the function. =COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed…
-
Determine if a reporting month is past, present or future
I have a project budget sheet, with a column for each monthly reporting period. I have a row that determines the actual month for each period, based on the starting date for the project. How do I determine status row if the if the reporting period is in the past, current or future?
-
IF function with several “than” options is “UNPARSEABLE”
I’m trying to use the formula below in a sheet to autofill one of several values based on a certain dollar amount/criteria. Logic: If “NAP” cell is between 2500-4999 then have target cell say “Builder’s Week”, and if “NAP” cell is between 5000-7499 then have target cell say “Green Out”…with several more options like this.…