-
Formula Help - Average IF
Hi everyone. I am hoping you can help me. I am trying to average the time it takes individual case managers to complete a case between specific dates. The reference cells are {CM Text} in the main sheet and it has to equal the name in [Case Manager]@row in the reference sheet The average comes from the reference identified…
-
Header Formatting for Formulas
How do you convert the first row to mirror the header row? The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we type in the header name, we receive error messages as if the sheet cannot find the information. We are thinking that there is a…
-
I need help with a formula that references one fixed date
I want to create a formula with a fixed date at the top of the sheet. There are subtasks with actions that must be completed a specific number of days before this event. Each row of tasks corresponds to a different timeline. Currently, my formula is =[Date of Event]@row - [Days Before Event]@row. However, this necessitates…
-
Trouble Coming Up with a Countif Formula...
I am trying to figure out a proper formula to count two criteria within one column and a specific date in another column and feel like I’m tried every one except the right now so far and whether I’d need an AND or OR option within the formula or something else. The columns in play are below: Call Status Column Left Message…
-
Create a formula using the outcome of another formula in a different column
Basically, I want to know all the Issues for the 4 stars groups. Im using this formula to count the multiple values in a column - =COUNTM([Issue]:[Issue]) But I want to say, all Colorado groups have (this amount of issues) which is the result of the previous formula.
-
I'm trying the CONTAINS and HAS formula and neither seem to work
I'm trying to count the number of times a word appears within a column range on another sheet; however, the cells I'm referencing have a dropdown so there may be more than 1 value per cell. I may be entering the formula wrong or not entering the right formula.
-
fixing this nested IF , INDEX/MATCH formula
I am having issues with getting this formula to work: =IF([Latest comment]:[Latest comment] <> "", INDEX([Latest comment]:[Latest comment], MATCH(MAX([Notes Last Modified Date - Helper]:[Notes Last Modified Date - Helper]), [Notes Last Modified Date - Helper]:[Notes Last Modified Date - Helper]), 1), 0) In the Notes last…
-
How to have the In Progress status be green when there are no start/end dates
Hello! I am trying to have the have the status show as green when something is in progress, even if it doesn't have a start or end date. I only want it to turn yellow or green when there are end dates involved. Here is my current formula: =IF(ISBLANK(Complete@row), "", IF(Complete@row = "Not Started", "Gray",…
-
Conditional formatting
Hello, How can I write the formula to show that if the date in column A goes past todays date, hightlight the cell in red? Is that possible?
-
Sheet Formula
Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying to get it to count all the dates in the column, but I also want to use to the formula to count all the rows with that same…