-
Any scripts/shareware to convert resourse reports to FTE/Labor Cost reports
Hi all, I've been exporting resource reports into Excel, then manually formatting/adding equations/creating pivots then importing back into Smartsheet to get the labor cost reports (FTE/person months/allocation etc) for a project. It's fairly straight forward but was wondering if anyone has optimized such a process. Also,…
-
Report not showing information from all sheets
Hello, I'm attempting to create a report from multiple sheets. The majority of the sheets are set up in the same format, but one has different information. It appears to be pulling the information for the similar formatted sheets, but not the one different sheet. The primary column information for all of the sheets matches…
-
Dynamic Gnatt Options
My team's project management process creates various stages of a project; I'm curious as to if there's a way to color code those stages within a Gnatt view on SmartSheet. Prior to utilizing SmartSheet we did a manual gnatt chart(see attached) that showed a color status under a color coded timeline of the various stages of…
-
Count of Requests/Emails Per Day
I am able to calculate today number of requests and total number of emails. I want to be able to calculate requests per day and emails per day. What is best function to use?
-
Saved Filters
I'm trying to put together a saved filter and I would like to have one of my filters sort alphabetical. Is this possible? Thanks!
-
Add Values in Column B, if Column A has a certain value.
Hello, Thanks in advance for any help provided. I date values in column A, the day a quote is signed. I have dollar values in column B, the amount of the quote. I want to total of the amounts in Column B that have an associated signed date. Basically, the total of value of quotes "unsigned." Pleas help, Smartsheet formulas…
-
Rolling Dates in a report
Hello. I have a project sheet to track individual projects. Each project is a separate row in the sheet, with a Start date, a Duration and a calculated Finish date. New projects (new rows) are added to the sheet via a form that that can be used by anyone from our web page. When the for form is submitted with a new project,…
-
Clone Column to another sheet
Hello, I would like to clone one or more columns from one sheet to another, I mean the complete column, no matter how many rows contain data. The columns in the other sheet should represent the data in the initial column. How can this be realized? Thank you.
-
% complete based on count of child checkboxes.
I'm hoping someone can help me. I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular…
-
Manager receives blank form
Hello all - I am new but really enjoy everything that has been shared and contributed. I sent my manager an Update Request for a sheet. He indicates that when he opens it, he only gets a blank page. I, however, am able to click the "Open Update Form" and the form opens right up for me. What might I be doing wrong? Thank…
