-
CountIF with dynamic criterion
Hi i'm trying to count the number of rows in a Smartsheet where the name in the "Engineer" column is the same name in the "Approved By" column I can get it to work by looking at a single row =IF(Engineer4 = [Approved By]4, COUNT(Engineer4)) but seem to look at all the rows in both columns and count the rows that match, is…
-
SUM totals of VLOOKUP
Looking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? (A): Forecast Adjustment forumla =IFERROR(VLOOKUP(Category@row, {Table Category_Full…
-
Help with an IF/AND/OR formula
Hello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to remain blank. Here is my attempt which returns an incorrect argument error:…
-
Nest if/or formula
Hi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows: If [Flu Vaccination Date] is "Blank" OR If [Flu Vaccination Date] is ">=" [Flu Vaccination Date]$1 OR If [Flu Declination Date] is "Blank" OR If [Flu Declination Date] is ">=" [Flu…
-
SUMIFS formula question
I’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way to do so even when the columns are NOT next to the other? Here are snapshots: The…
-
Launch manual refresment of all linked sheet and cells
Hi, I would like to know if there is a way to launch the smartsheet refreshment. I explain: I made many sheets with many cells linked together with formulas like Vlook up. When I change the searching criteria (for example a name include in a dropdownlist). I was expected that all formulas was update instantaneously but I…
-
Countifs project status is neither complete nor cancelled
I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I have other working formulas, but this is out of my expertise. Here's what I have so far.…
-
Using COUNTIF to determine dept. but excluding projects that are HOLD Status
I can't figure out how to do this formula and I've been searching for it in community. I've tried the following: =COUNTIFS(Portfolio Rollups Range 1, "Corp IT",AND({Portfolio Rollups Range 8},="In Progress",{Portfolio Rollups Range 8},="Complete") This one returns unparsable =COUNTIFS({Portfolio Rollups Range 4}, "Yellow",…
-
Automatically add formula to new row & apply @row to look at row above
I have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row. When i shift the row up or down within the sheet, it keeps looking the the balance original balance on the row that was…
-
Register and calendar integration
Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by…
