-
COUNTIFs for multiselect drop downs
Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal aligns to. They have selected the alignment to our organisational targets from a multiselect dropdown, and some people's goals…
-
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?