-
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!
-
Subtracting Days from a Date
Hello, I am trying to subtract 30 days from a column pulling in dates from another sheet using formulas and it keeps yielding an #INVALID OPERATION error. I have already checked and do not have dependencies enabled. Both columns are formatted as date columns. While playing around I noticed when I add the days it instead…
-
Blank do not Concatenate
Hello, I have a cell i use to concatenate a varying cells into one line and divides each text by dashes. Currently i'm using =column1@row + "-" column2@ow + "-" +column2@row Is there a way to spin the isblank( or if(blank formula so that if all columns 1 2 or 3 cells are blank it would not use the formula so that the…
-
Help with text formula based on date range
I'm trying to create a formula that essentially does this: If [Due Date]@row occurs next week then "Next Week" ELSEIF [Due Date]@row occurs last week then "Last Week" I was initially doing this with WEEKNUMBER, but that doesn't work when today and due date are in different years. I then tried doing date math by comparing…
