- Formula for Hours Scheduled by Month
We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please help?
- Exporting Sheets & Forms for a deliverable product
**this is cut from a support email thread I've been on for several days.** Replying to this instead of the previous thread. Backing up my sheet did not have the attachments included as described in the "help" ticket. Please advise on how to make this app work in a proper function to export all information and necessary…
- Construction Punchlist
我在寻找一个最佳实践当generating and maintaining a construction punchlist. Example workflow: you walk into a room, ideally with a Smartsheet form up and ready, specify the floor you're on, room you're in and then add a list of each item that needs attention/correction. Each item would be assigned to a…
- Manpower Loading Schedule
I am trying to create a Project(schedule) that has a manpower loading functions. I am almost there but I am stuck with trying to figure out how to see how many crew members I have on a certain days by suming them up. For example I would like to have a list of dates and then show how many crew members working on those…
- Is there anyone on the millwork shop side that can collaborate with me on how they use Smartsheet'?
We are a millwork shop that uses Smartsheet for all of our projects. I want to see best practices on how to use Smartsheets to our advantage. As of right now we have a "sheet" that works as our production schedule but it just seems like a big sheet with lots of data. Thanks in advance.
- Form Options - Automation
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…
- JOIN DISTINCT COLLECT or JOIN INDEX COLLECT w/ Multi Dropdown List
Hi, I want to return the "Assigned to" contact for the "Assignee Role(s)" selected in a multi-select dropdown list. Here are the formulas I've tried so far: JOIN(DISTINCT(COLLECT({Project Settings - Team Members}, {Project Settings - Contact Role}, CONTAINS([Assignee Role]@row, @cell))), ", ")) JOIN(INDEX(COLLECT({Project…
- Sum Collect - not working on new blueprint sheets
I am trying to reference a source sheet on project specific sheets rolled up from a control center blue print. I am using Sum Collect to gather the sum of transactions based on Project number, cost code and category. The Sum Collect formula is working on some sheets, but not others. =IF(Summary@row = 1, "", IF(Children@row…
- Looking for a cell value to trigger a formula
I'm looking for a formula to reference the value in a column then run a formula. I am using this to check the status of a contract then run a formula to see if too much time has passed in that status. If contract status is "In Legal" look at date sent to legal and make the value expired if seven days have past.…
- Looking for a labor capacity tracking solution - SS Resource options won't work
Hello, I've seen a few people asking questions that lead me to believe I am not the only person looking for a labor tracking solution NOT at the day level. To use the resource tools in SS we would need people to estimate their workload on a daily basis with start and end dates. We want people estimating hours per week per…
