-
Series of Checkboxes triggers complete
We're using Smartsheets to track our projects through the production process. We have one sheet that is just a list of the items, with 6 check boxes signaling that portion is complete. When all 6 check boxes are marked "checked"/true, I'd like the last column to automatically update as "completed." I've looked around and…
-
Hierarchal columns
I am very new to Smartsheet and have tried to search the community in the hopes maybe my question was already covered, but unfortunately, I did not find anything. I am hoping someone could help me. Is it possible to create a smartsheet like the below created in google sheets? The 1's and 2's represent checkboxes on the…
-
Automatic Move
One of the ways I use smart sheet is to manage my work load. Once a project is completed, I move it to a completed row to keep record of it. Is there a way to automaticaly move a row once the staus has been change to "completed"?
-
Financial/Accounting needs to expand Smartsheet in our company
I don't work in this realm at my job, but I know that another program (much more costly, I might add!) is being considered to meet our business services group needs. Though not exhaustive, I know they need a program that will allow for processing of purchase orders and needed approvals (electronically), timekeeping for…
-
VLOOKUP reference another sheet with parents
We are looking to create a formula to reference a date in another sheet (sheet 2) and than see if the referenced date in (Sheet 2)is before or after the date in the formula sheet (sheet 1). Forcing a check box or adding a visual identifier to the formula if it is true would be ideal. I've created this VLOOKUP formula, but…
-
Sums, IF statements and parent rows -- combined in one formula
I'm struggling to figure out how to combine two formulas. Context: my team doesn't like to think in hours, just general size of a task (S, M, L,) so I've created a helper column where each value relates to a number (XS = 1, S = 2, M = 4, L = 8, XL = 16), and an IF statement to return the values. This formula works fine in…
-
Report Template?
Is there a way to save a report as a template? Like, so all the columns & criteria stay, but can just choose a new sheet for it to look at? My team & I all need to print our sheets each week, and our manager wants them to all look the same & be uniform, which I thought the easiest way to handle would be to set up a report…
-
Dashboard Template Chart Works - Mine Doesn't with Same Config
I found a dashboard chart on a SmartSheet template that I'm trying to duplicate. I've verified the data in the chart is the same between "My Chart" and the "Template Chart". I've verified the chart config is the same. What the chart shows is different and doesn't seem to reflect my data accurately. What am I missing?
-
Row numbers to a dashboard
We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even if the row number shows up on the dashboard itself, that works - i can simply see that 45 rows were created in the last…
-
Hide Errors Until Cell is Populated
I'm calculating the variance between dates using the following formula. The problem is that an error is displayed if the Actual Start Date is not populated as show in the screenshot. Formula used in Variance Start Date: =NETWORKDAYS([Planned Start Date]3, [Actual Start Date]3) - 1 Is it possible to have the Variance Start…