-
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…
-
Multiple Forms to One Sheet
Hello! New to SmartSheet. Was wondering if there is any way to do a "Check-in" with multiple forms. For example, 7 unique forms with separate location/date (hidden values?) with one entry of an employee number. Then the sheet would have one row of data with the first column being the employee number and the second column…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
The IF function
I want to be able to type in the field if the Value is False. I can copy the formula to all the field in the column and overtype the formula. but if I convert to a column formula then I cant do this. Any ideas?
-
Trying to reference two sheets but having trouble with second reference
Hello, I created active project and archive project sheets. When a project is completed, it is automatically moved to the archive sheet. I set up a timesheet that references both sheets and looks for the project ID to automatically fill in the three fields for project name, project type, and solution type. It works fine…
-
Determining if all check boxes are checked.
How do you write a function to see if all boxes are checked on a row with multiple checkboxes? I tried using the SUMIF(Check_Box_1@Row = 1) and attempted to use a total number of checks to evaluate, but it does not like that. I tried using IF((checkbox=1 AND Checkbox2=1),"true","false) But that concept did not work either.
