-
Using OR in a SUMIFS or COUNTIFS Function
Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a particular columns if either one of 2 criterias a met in another column. My basic syntax is along the lines of: Sum all the values in column A, if column B has value…
-
Count Unique SME names
Hi. I have two columns SME #1 (Name) and SME #2 (Name) with names of subject-matter experts from rows 5 to 155. In many cases, one SME is assigned to more than one course (one course=1 row). I'd like to count the number of unique names in both columns. SME #1 (Name) | SME #2 (Name) Course 1 | Donald Duck | Course 2 |…
-
Count number of checked in a sheet
Hi Could tou please help me to count the nuber og checked rows in a sheets without making parent, children rows?
-
RYG Status based on Variance
Greetings, Does anyone know if there is a formula to automate RYG based on Variance? I am trying to track budget (not dates). I would like to show Red balls when a task is over budget. Any ideas on the formula? Thank you!
-
Special IF Formula for Stars
I have two columns: * [Infrastructure Project] is a checkbox * [Product Priority] is stars (0 - 5) If [Infrastructure Project]@row is checked, I would like [Product Priority]@row to be 5 stars. If it's not checked, I would like manual entry for the stars. This would be simple if [Product Priority] were empty, but I already…
-
Huge Sports Event in planning
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per team). My client does…
-
Status - Red, Yellow, Blue
I haven't done formulas in a while but can someone help me out with the following. I attached a screen shot below. If %Complete is 100% then status would be blue If end date is less than 10 days away then status would be yellow If end date is on or past end date then status would be red. Thanks
-
Referring to Adjacent Row
I am using the following formula in Color column to shade every other row in a sheet: ROW 1: No formula ROW 2 = IF(Color1 = 0, 1, 0) ROW 3 = IF(Color2 = 0, 1, 0) I have over 1,000 rows. This works fine. However, if I insert a new row, I have to drag the formula from the row above all the way down to the last row the fix…
-
Formula to Create Unique ID on Specific Rows
Hi Everyone, I am trying to create a unique ID but only on specific rows, so the auto-number column type is not suitable. I would like the ID to be sequential. I started by generating a number, 1, where Course and Action Due Date are blank. I have successfully done this by using the formula: =IF(AND(ISBLANK(Course491),…
-
COUNTIFS to include cells with text
I need to create a cross-sheet formula that counts the number of entries for a month and if there is text in another column. I've come up with the formula below, but I get an Incorrect Argument error: =COUNTIFS({Review Month}, =1, ISTEXT({Critical 1})) Where am I wrong here?