-
Countif for last week during new year turnover
Hello, I have a formula running to calculate how many ride alongs our team completed last week. During the first week of the new year, the formula no longer works correctly and I am having trouble trying to fix it so that it pulls last week (last week of 2023). I have this formula running on a different sheet than where…
-
Counting Columns based on if they contain certain words/names
Hey I have a worksheet that has several columns, what I am trying to do is count 1 column IF it holds "specific text/words" then to add onto this I need it to only count if a name shows up in 1 of 3 other columns. I've tried 15 different formulas now and none of them seem to be working. I thought it would be as simple as a…
-
Why is DATEONLY() returning the wrong date?
Hello All, Does anyone understand the behavior of the highlighted cell below? I believe it should be displaying "08/18/20".
-
Status based on Actual VS Targeted Dates
I need to have a formula for my Completion Status column. Here are the criteria and the screenshots. I keep failing at trying to write this formula, so I would appreciate some assistance. thanks in advance for your help!! The formula and all cells referenced are on the SAME sheet The formula is being written in the…
-
Using cells in a reference for a metric sheet
Hello! I am quite new to smartsheet and had a questions about some widgets. When referring to another sheet in my calculations sheet, I want to refer to a set of cells in a column instead of the entire column. However, I want it to update based on new info entered in the column. Also, anytime the sheet is sorted, it makes…
-
Count number of NonBlank cells for each name that appears on a sheet
Hello! I have a large list of repeating names (for our purposes let's say Susan, Jake, and Katie) that are assigned multiple Projects. For each of these projects, there may or may not be a note. I am trying to figure out how to count the number of times there is a nonblank cell for each person based on this dataset. Thanks…
-
Collect Hours Spent or Planned Hours for Projects using the "Business" plan only
Is it possible in the Smartsheet Business plan to utilize a form to input daily hours by a team member that would add up all hours spent against a project? I was thinking of creating a "Time Tracking Sheet" to be populated with new projects using the "copy project" automation workflow from a Master Tracking Sheet. Have the…
-
Using COUNTIF to return fields that contain certain test data
Hi Smartsheet Community, I am trying to create a Sheet Summary field. I want to count how many times my primary column has "D:" in the task name. When I use COUNTIF it returns fields that only contains D: in the field. (See my attached pic). Is there something that I am missing or should I use another formula?
-
COUNTIFS and SUMIFS functions?
I created a sheet that is a roll up of various information derived from a master sheet. I am using this to create a dashboard. However, I am stuck on a few formulas. I tried SUMIFS and COUNTIFS, but I cant get it right and either get invalid ref or unparseable. I would like to be able to count the number of stars appear…
-
Help with formula for "If column matches another sheet, check the box"?
Hello there, I am trying to get this result: If Branch # on this sheet matches {Branch Number} on reference sheet AND the {Month Name} on the reference sheet is "January", check the box. Thank you!
