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?
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
Is it possible to send an automatic Approval Request right after an automatic Update Request was filled in.
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…
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…
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…
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.
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…
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…
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.…