-
Formula stopped working
I have a formula that was working and all of a sudden stopped working but no changes were made other than new rows added. The formula looks for duplicates in either the employee name or employee ID: =IF(OR(COUNTIF([Employee Name]:[Employee Name], [Employee Name]@row) > 1, COUNTIF([Emp ID for duplicates]:[Emp ID for…
-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -…
-
To Pull a recent status from another sheet
Hi Hope you are doing well. I have one sheet "Sheet 1", in which we have 2 fields that will be filled through the form. One for scanning the barcode of the Product and 1 for updating the status of the Product Process for ex- Raw material at the warehouse, Raw material in the manufacturing process, etc. In the 2nd Sheet, I…
-
Solved: Subtracting time using formulas
Published Time of Day Conversion and Calculation sheet https://app.smartsheet.com/b/publish?EQBCT=6d765f7f8a864676b3b5d5f8fd866bf1 Original "Subtracting time using formulas" thread https://community.smartsheet.com/discussion/3795/subtracting-time-using-formulas @Shawn Roberts @J. Craig Williams I searched for "Subtracting…
-
A couple countif formulas
I have a couple formula questions: I want to count the number of employees hired from 1/1/21-until today (and have it update to be today in real time moving forward). So far I have =COUNTIFS({GB Users Source Sheet Range 1}, @cell = "Active", {GB Users Source Sheet Range 5}, "Full Time", {GB Users Source Sheet Range 4}, I…
-
Form attachment not showing in the Smartsheet grid
I have a form built for incoming requests that includes an attachment field. When the form is submitted, the document does not show in the grid (or any other view) as an attachment. How can I update the form-to-sheet flow to ensure the form's attachment is added to the incoming row?
-
Smartsheet marking items late -
Hi (Paul, if you are listening!) I have a formula that determines if an application is on time or late - It is marking applications that come in on the same day as the Final Filing Date as LATE (i.e., received date = 4/20/21 10 am, FFD 4/20/21 = LATE - however, these should be considered on time as the formula is saying…
-
Formulas | Green, Yellow, Red Health via Due Date
Howdy all! Long time researcher, first-time hair puller-outer :-) I'm hoping to create an automated RBY Health Column in my sheet based on the due date. I tried modifying some formulas based on what I've seen in other threads, but I'm really struggling and hoping to get some help from this community :-) Long and short, I'd…
-
COUNTIFS in a Date Range
I'm attempting to count how many times a sales rep's name appears in a column and the deal they're working on will be closed within a date range. I'm using a countifs statement with an AND for the criteria on the second range. I receive an INVALID OPERATION result when I use AND, but if I only look for either greater than…
-
I want to highlight a cell if the value is not in the pull-down list
I want to highlight a cell if the value is not in the pull-down list. Possible using formula? Couldn't figure out a way using conditional formula. Example = cell turns yellow when a value in a cell is not one of the pull-down values.