-
Assistance rolling up data to a master sheet
Hello, I’m trying to create a roll up for multiple resources across multiple sheets. I would like to have data roll up like how it looks in the Resource Allocation, but I’d like to view allocations in hours rather than percentages. I've attached an example of a project schedule in SmartSheet that we use. I thought that it…
-
Auto populate worksheet through hyperlinks built with web forms
My objective right now is optimizing my worksheets to have as little human interaction as possible beyond entering inputs. To that end I have users input their data through web forms to populate my sheets. My issue is that I cannot generate hyperlinks automatically on the new rows created by the web-form. I have…
-
Change Column Name in Multiple Sheets
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
Counting Total Number Correct of RYG Balls per person
Hi Can anyone help me with my a formula that will allow you to count the "Green RYG balls" which means completed for our purposes. I am trying to count the number of completed "Green" RYG balls, per person in order to use on the dashboard I am creating. I trying to display how many tasks has "John Doe" completed and I only…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
Deleting a Report Item also deletes it in the Sheet?
I came across an interesting interaction today while editing a report. When I went to delete an item off of the report, the item itself also disappeared from the sheet that it was associated with. Is there any way I can retrieve that information and have it back on the sheet but not the report?
-
Possible to create Gantt Chart in duration of "hours" for single-day projects?
Hi, I created a project smartsheet with gantt dependencies in duration of "hours" for an important project that lasts one day. I was wondering if there is a way to create a gantt chart that only displays one day but shows durations of "hours" on the x-axis instead? (The current gantt chart I see only displays 30 days…
-
Sending Attachments
I want to send/share a row with someone and I want them to be able to see the images in the attachments without having to open them. For instance, I need to send a General Contractor a Weekly Report of work completed. There are attached images on a row that need to be sent to him. I could share the row, but it would not…
