-
Flag column based on date & other criteria
I'm trying to figure out how to set up an alert to automatically notify someone if the entry row hasn't met criteria (checkbox) within 5 days. I was thinking about creating a flag column that kicks off an email alert but I can't figure out the flag formula. Here's what I've been trying to play with: If [Created Date] is…
-
Formula to auto calculate time difference in hours between two 24hr format times?
I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format. Once picking their starting time and end time, I would like the third column, "Total Hours", to…
-
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:…
-
Pulling in data from external source
I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing for an individual part. Since Smartsheet limits the row count to 5,000 I can't just…
-
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…
-
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…