-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
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…