Does anyone have a use case where they track uniform requests? We have a 8-10 types of uniforms that vary in sizes. I need to track (via form) what people want, and have it pull from our inventory. I'm just not sure the best way to set up my sheet. Any ideas are welcomed!
I am using Smartsheet’s Product Release Roadmap form. I added a start date and an end date to the cards so that the projects can span a period of time in the gant view. Is there a way I can make it so they also show as spanning a period of time in the calendar view? Currently, each individual card is only showing as the…
Hello, I would like to know if it is possible to create a formula that calculate the average % complete for all tasks that are ending at a specific date (important milestone) in my schedule. The schedule I have have a lot of tasks going all the way to 2020 but I want to track only those that must be completed by Nov 2018.…
大家好内容社区,我不喜欢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-…
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can use the new data to refresh/update a dashboard connected to that existing sheet?
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new workspace or folder for each project. I am hoping there is a way to make the project/sheet links stay within the…
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
