-
Collect Formula
Hi Brain Trust I am after a Collect formula or something………… I have a column that is being populated by a Datashuttle so have been unable to make it a drop down ( Datashuttle wont run if it is assigned as a dropdown) It is returning various selections ( from the Source) I need to separate this data into relevant Columns,…
-
Sum amounts within certain year and type
Hi, I have a report listing payment (i) amounts for various (ii) items and the (iii) payment date in long date format. I am trying to sum all the amounts per year and per item. Example: SUMIFS(amount, type = "paint", year = "2023") Adding up all the values in "amount" column if the type column is "paint" and the "date"…
-
Summary of Children
Hello, I want to sum up budgets for 2025 - but only for children rows (as I use the sum(children()) function in the parent rows - parents rows cannot be assigned to a specific year). The following function does not work: =SUMIFS([Budget]:[Budget]; (date:date); IFERROR(YEAR(@cell ); 0) = 2025);…
-
Sum Entire Column Starting at Row 4
I want to insert a Sum formula into Row 3 that will Sum all the rows in the column beginning at row 4 and continuing to sum any new rows that are added to the column. It seems like it should simply be =SUM([ColumnA]4:[ColumnA]) but this gets an #Unparseable error. How might I create a Sum excludes everything above Row 4…
-
Formula Remediation
I asked the AI tool in Smartsheet to help create a formula that achieves the following (the name of the "Engineer" has been changed for discreteness): i want to create formula that would give [Lead Allocation] * [WIP Revenue] when [Engineer Lead] is "Bob Smith" and otherwise give 0, but I want this formula to sum it up for…
-
Employee HR Metrics Dashboard Help
Hi, I am creating a dashboard that I want to be updated indefinitely using the data I add each month. I have one source sheet that I pull information from our HR system on a monthly basis to provide me with new terminations and such. I then have a source sheet that I used the "count if" feature to help get the number of…
-
COUNTIFS , based on previous days - not including current day
my current formula is =countifs(field:field, (@cell > TODAY() -7),….. or (@cell> TODAY(-7)…this comes back with a total that included today. Is there a way to count the seven days prior but not count the current day in the formula?
-
Seeing #UNPARSEABLE issue when applying formulae in the summary
Wanted to calculate the Average of time difference with some conditions like Implemented column is checked for the Level 1, and the final Level2 task is completed, then calculate time from the dates in the final level2 task called 'ECO Implementation". Here is the formula I generated but I see #UNPARSEABLE error.…
-
I need help with the RYGB Status Balls formula
Hello, I am trying to calculate health status (RYGB) for each task and milestone. Red= Not Started and past due, Yellow, In progress, but % complete is equal to or lower than 48% (.48), Green is in progress, % complete is equal to 60% or greater and blue is completed. I have read through many posts, but cannot seem to find…
-
COUNTIF between date range and 2 criteria
I am trying to cross reference another sheet to count all of the projects assigned to a specific person in between a certain range, but the # of projects assigned and the person assigned to the project are 2 separate criteria. For example, I want to know how many "A" projects that Jane completed in the month of January. I…
