-
Want a column to autopopulate parent taskname
As above. For reporting purposes, I want a column where all children rows automatically populate the parent row task name. Secondarily, if possible, I would also like a column where if a child is indented once, the column has one value (in this case, "Method"). If the child is two indents, the column auto-populates to…
-
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…