-
Pre-populate a form
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change control log.
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
-
Index Match or Index Collect with multiple criteria
I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row, {Scope of Work}, [Scope of Work]@row)) Solutions? 😁
-
Sum of column values that come from function formula
I have created a formulation of a drop down with prices associated with each selection that population on a different column: =IF([Repairs Needed]@row = "Tuck Point", "125", IF([Repairs Needed]@row = "Tuck Point Panel", "450", IF([Repairs Needed]@row = "Tuck Point Column", "150", IF([Repairs Needed]@row = "Tuck Point Major…
-
Week over Week Variance?
Hey Smartsheet Friends! We are operating in a Construction Environment where we are tracking an entire build schedule, start to finish. At the beginning of the project, we set the baseline to track the original start and original finish date. This allows us to understand the length of time that we deviated from schedule…
-
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
I am looking for a best practice when 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…