-
Plan vs actual hours
Does anybody out there track actual time worked to compare to planned time for a task? If so - how?
-
Reports Book Not Working
Hi, Not sure if anyone can help me on this, as Support haven't responded after emails sent 3 weeks ago... I have created a report that pulls in information from different sheets, on specific criteria. when i set this criteria in the filters section on each individual sheet, i return 243 results from all 3 sheets combined…
-
Source Table for multiple sheets individual drop down columns
Good Afternoon, I have multiple sheets (50+) that utilize drop downs to look up data specific to an individual record. The individual record for example would be a location number. We add locations on a monthly basis and i need an easy way to update the drop down option from a central location, vs having to update each…
-
Ability to "lock" rows based on a response in a cell reference
Looking for a way to write a formula to lock rows if a cell has a specific value in it, or hide the rows. Any ideas?
-
Automating updates from shared Excel doc to a Smartsheet doc
Is there a way to automate updates from a shared Excel file to a Smartsheet doc? I am currently manually entering data from an Excel file into a Smartsheet to update the information on a Sight. It would be great if the data was automatically updated in the Smartsheet when the shared Excel file is updated. Is that possible?…
-
Unable to open reports
Hi, Im unable to open any reports. This is not a transient issue for me. Each time i try to open a report, whether i have created it using a "new report" option or if someone has share with me, i have this error. formName: ajax formAction: fa_loadContainer serverStatus: false serverStatusText: CriticalException errorCode:…
-
What the best way to manage 8,000 Projects in Smartsheet
I am new to Smartsheet and not sure how or if the program can help...I have project where I am rolling out a new program to 8,000+ locations and looking for way to leverage Smartsheet to manage. I know there is a 5K row so not sure how to proceed. Most threads talk about pulling rows out once complete but my project is a…
-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…
-
Filter rows based upon unique value
I created a report that retrieves the Assigned To column field for all of the rows in a project sheet. There are several rows where the same resource name is shown in several rows. How do I filter all of those rows into a list that includes just the unique resource names for all the project rows? Do I need to do some…
-
Report Builder Enhancement Request - filter on sheet name
I would like to run a report on tasks per employee assigned with in a workspace. This is pretty straight forward and easy to accomplish. It becomes difficult to do when the sheet count for a work space goes over 250 sheets. In my workspace, we typically have 15 sheets per clients, and with over 20 clients in a workspace,…