-
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…
-
Auto format phone number
Good morning, I'd like to have our phone column (text) formatted so that when I input just the numbers (ex 7195555555) it would format the number as (719)555-5555. Help? Blessings, Loann
-
Help with a join formula to view two columns in calendar view
Hello! I have several projects with many rows of information per project on one master sheet. I use conditional formatting to seperate/identify projects by colour. That colour coding applies to both grid and calendar view nicely. BUT I would like to combine a project code and task name in calendar view so I do not have to…
