-
Creating workflows for repetitive tasks in Smartsheet
Hi How do I automate the workflows in smartsheet for repetitive tasks? For example Scenario 1: The issue has been raised by Testing team - which goes to the Development team, they modify the code, Testing team tests the modified code - if the issue is resolved, the issue is closed, if the issue is not resolved the cycle…
-
IF / OR formula help
Hi community, hope somebody may be able to help. I am trying to link a % of completion column with a progress bar. Formula is as follows: =IF([% complete]1 = "0", "Empty", IF(OR([% complete]1 > "0", [% complete]1 <= "0.25"), "Quarter", IF(OR([% complete]1 > "0.25", [% complete]1 <= "0.5"), "Half", IF(OR([% complete]1 >…
-
View Cell History not supporting Comments
Hello All We frequently use the comments cell in rows to register and monitor a line items progress over time. This means that some comment threads would have participation by a number of users and over longer periods of time...so far so good However, while it is possible for the comment writer to edit/delete the comment,…
-
why does smartsheets not Sum Cells with leading zero values
I am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN})) Mth/Yr = 9-2019 Prev Yr Mth/Yr = 9/2019 DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99) The result from the SUMIF is 0 (zero) Does SS not add values with leading zeros? What am I doing…
-
Is it possible to apply Conditional Formatting with a formula?
In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below. I need to compare column values to the value at the top cell. I can do this by adding more columns and formulas and then hide them, it would be cleaner if I can do with conditional formatting.…
-
Formula to Automate Stage
Hello - I am trying to figure out if there is a way to automate the selection of one of three stages (Not Started, In Progress, Completed) based on Start and Due date columns. Activities with a Start Date in the future would be 'Not Started', activities with a Due Date in the past would be 'Completed' and anything with a…
-
AVG(Collect) Formula help with date range
Is there a way I can give a date range in the formula below so that it averages between dates 8/21/19 - 10/29/19 =AVG(COLLECT({Nexus Dependencies Range 5}, {Nexus Dependencies Range 1}, "The Scrum Lords", {Nexus Dependencies Range 3}, DATE(2019, 10, 29)))
-
Parent and child relationship in CardView
Is there a way in CardView to show the Parent / Child relationship? For example, If in Grid view, row 6 is the Parent of rows 7, 8 9, and 10. In CardView can the card equating to row 6 be left justified and cards 7, 8, 9 and 10 be slightly indented to the right. Further in CardVirew being able to collapes rows 7,8,9,and 10…
-
Conditional Formatting if Checkbox is Checked
Hello everyone, I created a checkbox column with 3 cells set to toggle on and off conditional formatting rules. My idea is to paint certain cells if certain conditions are met AND one of the 3 cells is checked. I'm doing this mainly for aesthetic purposes as I don't want to have my sheet multicolored all of the time. Using…
-
Indefinite Lag Times?
Hi, I am trying to set up some predecessor relationships between tasks that don't have a definite lag time associated with it. I just need the relationship to require Task A to wrap up before Task B. Task B doesn't need to start immediately after Task A is done, but it CAN NOT start before. For example, I am doing a…