-
Can anyone recommend the best formula to calculate overdue tasks?
Currently using- =COUNTIFS(AND({SS Project Plan Completion Date Range}, NOT([{SS Project Plan Status Range} = "Complete")]) < TODAY()) I want to exclude completed task from the count. Currently returning UNPARSEABLE error
-
I need a checkbox formula where criteria is one of many dropdowns selected for a given cell
I'm trying to write a formula that would check a checkbox if a dropdown selection is chosen for a specific cell, where other dropdown selections are also chosen. E.g. Dropdown selections a,b,c,d are all selected as all apply, and I want a checkbox in a separate column to populate if selection 'a' is amongst those chosen.…
-
#UNPARSEABLE: Trying to count two selections as a total based on assignment and a label of "engaged"
-
Date autofill to most recent date entered
If you have a parent row with a blank date column and "children" rows with dates listed in each separate row, is there a way to have the parent row equal the most recent "child" row date?
-
Update Request - Shows Sending, but Not Received
Hey all - Been using all the great functionality of SS for quite some time now. I have an Automated rule setup so that when a person Submits a certain thing, an Update Request is Automatically triggered. I've had several of our AEs reach out saying they're no longer receiving them, but when I go into SS, I can see that the…
-
Formula to check box when 2 criteria are met: older than 180 days and another box is checked
I can't get get my formula to work. I am trying to get a box in one column to check when the date in another column exceeds or is equal to 6 months (180 days) and when another box in a third column is checked. This is what I have, but I think it's the checkbox condition that's throwing things off: =IF(AND([Start Date]@row…
-
#Invalid Operation Error subtracting days from another Date field
I have a sheet that has a date field that is link in from another sheet (actually 2 other sheets) that is not working as expected and I cannot seem to root cause the issue. I have a column 75%/SD Date that I want to get 14 days before it in another column. Below are some things I have put in for the formula and the result…
-
Current vs Previous Fiscal Year-to-Date Formulas
I am trying two compete two formulas that will both calculate a YTD total that compares the number of "resolved" tickets to date in the current Fiscal Year and number of tickets "resolved" the same date range of the previous year. Here is what I have, but the result of both calculations is returning "0," which perplexes…
-
How to create metric from timestamp in sheet
I am trying to create a metric in my dashboard that shows the average time of day that each contact submitted their request. The specific date is not relevant. Please help Thanks!
-
How can I fix my sum formula ranged whenever I have new inputs from Forms?
Hi, I have sheets where I am collecting the data using the form. I have setup my form to put new submitted data at the top of my table. My problem is , when new submitted data was collected the range of my formula is being changed and not getting the new collected data. See the Total formula. Please help me to fix the…