-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?
Right now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to manually input new columns after the initial 12 week period is up. It's a time…
-
COUNTIF Query
Hi All, I'm trying to run a query to group and count certain status' in order to count them as a single statistic. For example: If there's 4 'New / Reported' tickets and the 'Pending External Clariication' has 5 tickets, the OPEN tickets box would show 9 OPEN tickets. Ticket classes: Open ticket = The status' (New /…
-
Smartsheet and Procore Integration
Has anyone used Smartsheet hand in hand with Procore? Background: My company is the design team on a construction project. We are using Smartsheet to handle workflows and documents questions from our subcontractor. The subcontractor is managing the schedule and is using Procore for that piece. Does anyone have any examples…
-
Notifications for adding people to a workspace
I'm wondering if I have something set incorrectly. I have a workspace that I want to limit access to. I noticed today that people with access have been sharing the workspace with others and now I have a ton of people in that workspace. I'd like to get a 'Request to Join Workspace' notification and then approve them before…
-
report: take over colors in grid view of a project
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (file 1). --> Until now all fine thanks to the "link from other cell of sheet" this has…
-
Automatic Breakdown of budgeted hours into cells
Hi all, I was wondering if there is a possibility of creating a formula that would autopopulate cells based on months duration and budgeted hours? E.g. if my study starts in september 2020 and lasts for 10 months, it would autopopulate cells in respective columns? (see snapshot of how the sheet looks) Many thanks
-
How are you using Smartsheet to help you homeschool during COVID-19 closures?
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times per day. We've been getting a ton of work done without ever changing out of our pjs!…
-
Reporting on who and how many times an individual has attended events
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all the data about who is attending our events is in multiple sheets. Using email…
-
Index Match help
I am trying to convert from Excel to Smartsheet without adding a ton of columns to make this work. I am not if Index/Match is the way to go OR VLOOKUP, etc. Again, the entries from the operators will vary therefore the low/high specs are used in previous columns that you helped me with. This is the excel version of ONE…
-
Building tasks in Smartsheet: How to sort by dates instead of parent groups
I'm in the throes of building my first sheet and have finished setting up the dependencies and key tasks I need for my project. Tasks are set up by parent/child groups, based on task type. Now I want to build out the rest of the year using similar tasks. At this point, I want to be able to manipulate the sheet to look at…
