-
#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…
-
Averaging numbers that meet a defined criteria
I'm creating a metrics sheet to feed a dashboard. On this sheet I am referencing a different sheet with the data. The formula I need to create would do the following: 1) AVERAGE the numerical values in one column. 2) IF the data was collected in a certain month, which is identified in a different column. So for example, I…
-
Regrouping Delimited Data
I pull data from an internal system and add it to Smartsheet via Data Uploader. When it comes in, it looks like the above, with Biz Entity, Sub Business Entity and Product Family grouped as delimited data. However, I want to regroup it so that each Biz Entity/Sub Business Entity/Product Family group is together in a single…