-
Need to have a dashboard show only Current Month status but different column for each month
Hello! To explain: We have a goal-setting Smartsheet template. In the template, there is column for each month (the row is the goal) So, for row #1 (the first goal), there will be a column Q1J (Jan), Q1F (Feb), Q1M (Mar), Q2A (April) and so on. The end users I want to only fill out the column for the month we are in, and…
-
Help with Parent Check Box and Children Aligning
Hello, I am trying to get he children to automatically be checked when the parent is checked off. I was trying to get a helper column to assist, but something is just not clicking in my head to make this work!
-
Formula to total together and count a status & count completion
Hard to title... But refer to the attached screenshots. On the parent task right now I have it counting the amount of child tasks' status (the progress bar). As you can see under the expanded task of "External Kick off" there are 5 other tasks. I have set them as Full on the status bar as shown and so the "External Kick…
-
Automate RYG Balls based on Status and then date
Does anyone have a formula that looks at a line status (Not Started, In Progress, Complete) and then determines whether it is after the due date (red), <7 days (yellow) , or >7 days (green)? Complete would need to turn green regardless of the date while not started and in progress would look at the date parameters. Thanks…
-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…
-
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
-
LOG Function
Is it possible to calculate (or even approximate) a LOG function in Smartsheet? We regularly use the below formula to calculate A/E fees: (35/LOG(Construction Cost))-1.15)*(Complexity Factor) = A/E fee % I have a sheet setup where someone can enter a construction cost, and a lookup table for the complexity factors based on…
-
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…
