-
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…
-
Using IF -> Cell Reference -> OR
Hey folks, Basically I'm trying to put a cell reference in between two logical statements. In this case, if either "Person A" or "Person B" are in the cell, return "Team A". Here's my formula: =IF([Assignee Contact]@row = (OR("Person A", "Person B")), "Team A", "N/A") I can't find anyone indicating that this is even…
-
COUNTIFS 4 variables
Hi, I need help with this formula. As you can see I am hoping to count when the name: Category Management is found in FUNCTION 100% is found in PERCENT COMPLETE S-CL is found in PERIOD and Day 1 is found in PERIOD Goal is that if all attributes are found, the count and provide a total. My formula is below.…
-
Make on weekend as working days
I need to make one weekend as working days in my project. I don't want to create a parent task with sub tasks. I want to force the weekend to be a working days. I appreciate your help
-
Checkbox & Pulling back values in a cell
Hi, I've done my research and it looks like people have had to use Zapier for this specific use, but want to throw it out there again before i go that route! I am looking to pull back a value from a row where a box was checked. So i am thinking that in my formula sheet i can create a formula that basically says 'if the box…