-
Numbers won’t add up on construction template?
It has to be easy? Or the way I copied and pasted? It’s the template for construction estimate? Some of my numbers won’t total-and the very top number for total for entire estimate won’t populate?
-
Is there a way to add a Dashboard to another Dashboard so it shows up visually like a report?
I was able to add a link to the dashboard but would love for it to show up as a visual instead of just a hyperlink. Thanks
-
Trigger Approval Request with the submission of an Update Request
Is it possible to send an automatic Approval Request right after an automatic Update Request was filled in.
-
Automation 'Copy to another sheet' doesn't work
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
-
Creating a Report that ONLY shows rows with Attachments
Is there a way to filter out rows that show up in my report that do not have attachments? I'm building a report that shows my subcontractors any row that's had an attachment added to it in the last 7 days, but I can't seem to find a way to get the Report Builder to only show rows with attachments added. I realize I could…
-
Manpower Boards in Smartsheet
Hi there! Is anyone using Smartsheet as scheduling tool for weekly Manpower, basically for the field staff, supers, Forman etc. so they know which project to report to week by week. Used excel in the past but wondered if anyone found a good setup for this here. Would love to hear some ideas.
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
Mutiple forms for a Single Row/Workflow
Is it possible to have more than one form fill out a single row. So I have a form to fill out the initial set of cells for a request. This then triggers a work flow to fill the request on one end. Once the request is filled and the request date is completed I have another workflow set up to go back to the initial requestor…
-
Child Rows Automatically Move to Parent Rows Based on Column Cell Value
How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is changed to not bidding then I would like for it to move to the not bidding parent.…