-
SUMIFS with 3 criteria
Why is this function not working? =SUMIFS({Mai'23 Datenbank}; {Gruppe Datenbank}; Gruppe@row; {Ressourcentyp Datenbank}; [Ressourcen Typ \[FTE\]]@row); {Priorität Datenbank}; Priorität With only 2 criteria it works fine but when I add the third criteria smarthsheet will show #UNPEARSEAPLE I want to SUM FTE (Mai`23…
-
Scatter chart not displaying all data
How do I create a scatter chart from 1 text column and 2 data point columns? Each data point should have text (SUS g) next to it that relates to the data point
-
RAID Log Date Value Locking per column when status changes
Hello everyone, I have tried to find the best answer for this but I see too many threads and different responses. If anyone could help as I am new to this. I am only looking to lock in a date value on 2 columns whenever there is a status change, from when an issue is raised and then resolved. I know there is a record a…
-
Formula help: Counting user experience by date
Hi there, I am trying to create a formula to count by user experience (e.g., Positive, negative, Neutral, N/A) for each month. For example count if a response is in September and it is positive. I am referencing a different sheet and I have tried a few different formulas but I keep getting errors. I am assuming I need to…
-
IF formulas to generate month from a date column
I am having trouble with a SUMIFS formula. I want to calculate the revenue for sales in August 2023. I want to add a chart to a dashboard that shows the revenue for each month, and have the months appear in chronological order. I have a Revenue Column, A Ship Date Column (we use this to help manage "end of month"), and…
-
Parent/child roll up formula
Does anyone have feedback on the formula below? I may have some parentheses where there shouldn't be. Here is what I am trying to accomplish in the parent cell: "Complete", if all children are "Complete" Leave the cell blank, if all children are blank "On Hold", if any children are "On Hold" "Requirements Needed to Begin",…
-
IF Function Due Date
I am attempting to create a "Current Status" column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my "End Date" column is 90 days prior to todays date. If the "End Date" is 60 days before todays date, then I want it to change from yellow to green. If…
-
Using multiple IF(AND) statements in a formula
Hello, I am trying to create a column formula that will update Schedule health to a red, yellow, green, or blue circle using multiple IF and IF(AND) statements, but I continuously get the error message "#INCORRECT ARGUMENT SET" Here is my formula: =IF(IF(AND([End Date]@row - [Today's Date]@row <= 0, Status@row = "In…
-
Formula when a column has a checkbox
I cannot seem to find this answer: When a column has a checkbox, another column must have data in it or it will turn red Example. If someone is needed on site (it is checked) then a person(s) name must be in the box. They cannot leave it blank or it will be red. On Site Person <star> Contact List or cell is RED
-
Non-date default values in date columns no longer possible with forms
I had a problem and fixed it by hiding a non-date default value in a date field as part of a form submission, but now it's not working anymore. Is this intended? This helped me avoid unnecessary helper columns, but now I will probably need them unless it's fixed. edit: removed confusing explanation.
