-
Project Management/PMO tips
Hi All, I'd be interested to hear how others are setting up smartsheet to support large programmes involving many projects, with multiple organisations, exec sponsors, and project managers. I work in the National health Service (UK) and have a master project list that contains summary information for around 200 projects,…
-
Novice user, Build Reports
Hi. I have a sheet in which we enter transactions and the date they occur. I would like to generate a report that sums the number of transactions over a certain period. This report could then be emailed or accessed via URL, etc. Is this doable? Thanks!
-
Formula Help
I am trying to match a cell on our contract status report and pull that cell information into our recruitment sheet. On the contract sheet name is in the first column and contract status in the sixth column. I want the contract status to populate into a cell on the recruitment sheet by name. I was thinking that VLOOKUP…
-
Linking colums from one sheet to another issue
Good morning, I am trying to set up a master document with linked cells across three different sheets. First being an order form, second being a shipping form and third being an install form. All the information will link back to my system ID of which system is being installed. My question is when I highlight my cells I am…
-
Cannot Copy Chart Formats with New Data
Hello, When I copy a graph on the dashboard it keeps the same formats (color scheme, grid lines, etc.), however when I change the data I want to look at it completely reverts back to defaults even if the data is the same # of cells and the same type of cells. Is there any way to keep the same formats but change the data…
-
not able to paste to the column with ID number
hi, I have removed a number of rows from my smartsheet. now I want to paste the data from another sheet but the system would not allow me to paste to the column with the doc ID number which fills in automatically. I would like to keep the original ID numbers therefore I would like to paste them from another sheet. What can…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Error With % Complete Child Roll-up caculation
Hello, My team has requested that we use an average % complete of the child cells to populate the parent cell. I am struggling to get this to work. Does it matter if you are rolling up % complete that have already been used in a average formula? For example Task 1 % Complete is calculated by averaging % Complete for Task…
-
Cannot add field to attach files
Hello everyone. I am working on a sheet that will store files sent by third parties. But currently It does not give me the option to place a field to ask for attachments on the form I am working on. I started to use Smartsheet recently, so it can be quite easily to solve this problem, so please be patient. Ty all
-
Averages
Hello all. Thank you for any help you can provide. I have 5 fields containing averaged numbers. I want to roll them all into 1 field to show the average for that specialty. Anyone know of the right formula to use? In English, I have the average for 5 counties for primary care clinics and want just 1 average for the…