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…
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 ha…
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…
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 …
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 relat…
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 …
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 co…
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 …
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 V…
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
