-
Multi-sheet Kanban
We use a checklist with 340 lines. We currently create a new sheet for each project. We would like to create a kanban that links these projects utilizing the highest level of the hierarchy as the lanes (5 lanes) and the next level as dropdowns in the cards (9 at the most.) The third level is where the actual tasks are but…
-
Formulas In Templates Reference to another Sheet
Is there a way to save a sheet as a template that has formula references to another sheet and be able to easily change the reference when using the template? I have a summary and detail sheet that I want to create a template for future use. The summary references the detail. I'd like the Summary sheet to maintain links to…
-
DATE function for drop down menus
Hi all, I am using a drop down including different years (2019, 2020, 2021, etc.) that I need for the card view. Based on the selected drop down value in Column 1 (e.g. 2020) I want to auto-populate a ‘date’ field with the first day of the year (e.g. 2020.01.01) in column 2. I tried to use the following: = DATE ([Column…
-
COUNTIFS with more than 2 criterion
Hi, I am trying to do a count for a field with 3 criteria. I want to do COUNTIFS( A = "x", B = "y", and C = "Z"). Is there a way to achieve this as COUNTIFS only allows you to do this with 2 criterion?
-
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…
