-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
-
Help to create a formula that sums a column based on if values in two other colums are correct.
Hello, I have three columns that need to be in a formula. TIME, Y, Z I Want to SUM all the rows under the "TIME" column based on if the Y and Z columns have the specific dropdown value. This was my try but it did not work: =SUMIFS([Z]:[Z]; "Approved"; [Y]:[Y], "", Time:Time) Can anyone help? Kind Regards, Hugo Martinwall
-
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…
-
Help setting up inventory tracking
Im using inventory template. Need a little help setting it up. We receive shipments of doors that we temporarily store in our warehouse. The doors go right back out to job sites, based on installation days. Here's are the processes I would like to design 1. receive shipments. check off that all doors are accounted for. 2.…
-
Huge Sports Event in planning
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per team). My client does…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,…
-
Non-Task Related Project Description/Information/Demographics
Is there a way to add Non-Task Related Project Description/Information/Demographics to a project without using rows? I feel like we need a demographics page that we can add non task data.
-
Macro or VBA funtions
I'd like to be able to create a macro or VBA code that would allow me to create a job folder on our local server using data from my smartsheet. The VBA code in Access looks like this: Private Sub cmdCreateCaseFolder_Click() If Dir("\\MA021SFS01\NorthEast_EWP\2018CaseFolders\" & Me.Project# & "-" & Me.Project Name & "-" &…
-
Publish a shared google Calendar in a sight
Hi there, I've imported our team google calendar into a smartsheet no problem, and I can see all the entries, however when I try to present this in a sight the calendar grid is displayed without any entries. I've 'published' the source sheet with the calendar import, and both the source sheet and sight are shared with all…
