-
copy rows with formula's
When I copy a row from one sheet to another sheet; all the formula's in the cells are replaced with values in the target sheet. So my formulas are gone in the new row that appears to the target sheet. Is there a way to have the formulas copy over in the row so they are intact in the target sheet?
-
Question
Has anyone used Smartsheet to track company vehicle miles, gas usage, etc.
-
Production/Manufacturing/Importing
Hi we do alot of importing of containers and production/manufcaturing jobs is there a smartsheet that we could use to have all container imports in one place? what would the best template be to use? It would be easy to use one sheet for each but we really want to have it all in one place if possible?
-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
-
On the Home Screen why do some users not see the Resource Views tab?
In working with my team I see that some of their sheets are overallocated. When we go to modifiy it when they are signed into SS there is not Resource View tab. Any direction on why and how to fix the little red markers would be greatly appreciated :)
-
Universal Unshare/address book of sheets shared to User
Is there an address book feature that shows which sheets are shared to individuals with a universal “unshare" option?
-
Why switch from MS Project to Smartsheet Project?
I'm new to Smartsheet and am considering in switching from MS Project to Smartsheet but there seem to be limitations: 1) Progress Lines - either I can't find it or there's no on/off for progress lines. it's quite messy when you have 1000s of entries. 2) Views - can't customize views based on users and audiences 3) Duration…
-
Summarize Columns in a REPORT, not a Worksheet
I've looked far and wide, and haven't found a way to summarize column data in a Report. My team uses a single "Status Tracking" Smartsheet, which has a large number of columns. For some of the columns in that worksheet, I have created Summary Rows with Count or Average Formulas, so I can determine the number of records for…
-
Restore a prior iteration?
Gant function threw off all my external links in a prticular column. Not knowing this had happened, I had saved the work. Is it possible to restore a prior iteration of smartsheet?
-
Summarizing Data using CountIF
I have created a Status Tracking sheet with multiple records. Each record represents a summarized view into a detailed task template. Each record also has a Status field, which we use to describe the phase of the project that we are in (there are four phases). I have used Countif to count the number of records in a given…
