-
Combining "blank" cells with a checkbox - notification
I am trying collectively check the box for "MIssing coating Weights" IF - one column of each coating weight is blank AND the Recheck and/or No Coating Weights Required box is NOT checked. Thanks! =IF([Recheck and/or No Coating Weights Required]@row, 1), "", IF(AND([1421 CTG WTS OP]@row = "", [902 CTG WTS OP]@row = "",…
-
Index Collect First Value from A Column
Hi All, Having trouble with index collect, I have a formula in a cell that I've added +"" to make it a text (Sprint Planning) and under Planning Header am trying to have a formula that essentially states: If the sprint value column is not empty, then return the first text value =IF([Sprint Planning…
-
Have a formula that numbers rows and want it to only count certain rows
Hello, I want to sort items by priority based on order of the rows in the Smartsheet. So, I want lower numbers (rows towards the top) to be shown as a higher prority. I am using the formula: =MATCH([Task Name]@row, [Task Name]:[Task Name], 0) However, I also want to only include certain rows. In particular, I want to only…
-
SUMIFS with 2 criteria coming up zero
Hi! This formula keeps returning a zero. I am trying to get it to count two different things in the same column (not sure why they were labeled differently) but when I get the formula plugged in it comes back with zero, when I know that's wrong. I want it to count up the engineering hours based on the product lead,…
-
INDEX/COLLECT Q: Running into issues pulling data from another sheet based on 2 criteria
I am attempting to pull attendee numbers from a master grid to a summary sheet. Our master grid has upwards of 30 columns and is used as a central repository for event-related information across multiple years. I have been tasked with compiling a dashboard for our senior/executive leadership to showcase the total # of…
-
Sum Time Difference in Quarters between 2 Columns
Is there a way to sum the time difference between two columns There is two columns "Start Time" and "End Time". If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it to calculate 12 hours If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate…
-
Is it possible to do calculations between Summaries of 2 different Sheets?
Hello, I'd like to calculate a value that is simply a subtraction of Summary fields on 2 different Sheets. It's ok if the calculation formula is on a sheet, a report, or a dashboard, doesn't matter. I just need Smartsheet to subtract the two Summary fields. I am a beginner user so any help is appreciated. :) Thank you!
-
Calculating a date up to 60 months in future
I need to calculate a future date from a past date + a number of months. I have a working formula but it breaks after 14 MONTHS . I think it creates some sort of circular reference error after it passes the current MONTH in the following YEAR but am so far unable to correct the issue. I think i need to nest some additional…
-
Predict or set which row a form writes to
I have a sheet that I am using to gather data from several different sources. I will need to create at least two forms for this which I will use to populate the top part of the Sheet. I am using an Index/Match to go to the row data that I need to pull from the forms responses, and that works great. Here's the issue: When a…
-
IF Statement Returning Incorrect results
I tried the AI feature for writing formulas and it gave me a slight variation of the formula below. I want it to look at the Discovery Completed column and if the box is checked then it should display the information in the cell for the Implementation Project Stage. If the box in Discovery Completed is not checked then it…
