-
sheet summary, countifs task status
I have a simple formula, i can't seem to get working. reads - invalid data type In the sheet summary i want it to count the task status, (Red, Yellow, ...so forth) When i put in specific range ie [Task Status]2:[Task Status]100 - it seems to work fine. but when i wish to calculate the entire column. (*some rows may be…
-
Keeping track of your Task IDs
This is not necessarily going to be of any use to you, but I can tell that you're curious... The sheet has an old list of tasks and ID numbers at the bottom - a sorted list above and logic to find matches/duplicates.
-
Send an automated response to the sheet owner email address the moment I receive an alert ....
I share as a viewer for a smartsheet model for which I receive alerts when the model changes. Is it possible to send an automated response to the sheet owner email address the moment I receive an alert that has certain characteristics? The backstory is that my condo association posts available units and the owner that…
-
Nested IF Formula - with drop down list
Hello, I'm trying to figure out how to create a really long IF formula based on options provided in a drop down list. I'm having students select their major from a drop down list. Depending on what major(s) they select, I'd like to auto populate the division that that major is connected to in a different column. For…
-
If/And formulas
Hello All, I am trying to create a formula where I want to see the sum of all positive test results if the testing date is within the last week. This is what I have so far and not sure if I am even on the right track. =SUMIF(AND({Employee Surveillance Testing Range 1}, >0, {Employee Surveillance Testing Range 4} - TODAY()…
-
Can I use an INDEX formula to retrieve value from another INDEX Formula?
Hello, I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error. They are as follows: "IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retrieves the value I want. "=IF([Nov-19]110 = 0, 0, INDEX($[Jan-19]$189:$[FY50]$189, 1,…
-
SUM "Duration" based on date Range
I have a sheet with an "End Date" and "Duration" columns. I need a formula that will look at the "End Date" and see if it is equal to or between two dates and then SUM the duration. Ex. Date range 6/8/2020 through 6/14/2020 and I want to SUM the total duration. Thank you in advance.
-
Row and Sum calculations for Capacity Management
So, until we get 10k feet, I am trying to figure out how much of our team's capacity is spent on projects or operations work. In the sample below, I'd like to know how much time teams and sub teams spend on Projects, Operations, Enhancements, and Admin. There may be muliple project, operations, or enhancement rows. I'm…
-
How do I round a formula answer?
The above is the average formula I am using which gives me the below answer. I want to round it to a whole number.
-
Select separate values from multi-select cells
I have a sheet where staff input their hours available in a week. I have the formula to calculate the hours available for the week. However, staff can enter multiple start and end times, if they are available from 8:00am - 10:00am and then from 3:30pm to 5:00pm. The formula still works for the first set of numbers, but…