-
Can the Live Data Connector work with QuickBooks desktop, QuickBooksOnline or Xero.com?
We currently use SS for all of our project estimating. We love it. We are currently exploring using SS to also produce our job cost estimate versus actual reports. (construction company). I see a couple of options. First, we can pursue a "one way" push utilizing zapier.com to auto entry into a spredsheet that could be…
-
Does anyone have any great manufacturing process systems
I am always looking for some ways to improve our sheets and the overall system. i run a manufacturing company and I am looking for anyone who is will to share their flow in smartsheet. We do a rebuild every year and do a planning week to refresh our processes. It is time to do this so any shared ideas would be great.
-
timing of the Run workflow:Daily ?
Hello, If I set the change action like below with "Run workflow:Daily", how the recurrence occurs? lets say, the requests come in at 9am, 11am, 3pm, 4pm, 9pm on the day, how the run works on the day and next day? Thanks, Hana
-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Dynamically Updating Row Information
I am looking to dynamically update add or delete a row in a sheet based on a checkbox on another sheet. Specifically, we have a sheet that contains all our outstanding balances, and a sheet that contains all our job info. We are looking to have it add a row to our balances sheet when our checkbox isn't checked, and delete…
-
Approval Workflow
Hi We are looking to use approval workflows for approving Quotes within our system. We will attache the quote to the line however I was wondering if there is a way within the workflow to specify which attachment to approve rather than seeing all attachments? Rs Abbie
-
Sumif across Children and Grand Children
Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here are the formulas I have been trying: SUMIF($[Payment Status]5:$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50)) => result to #UNPARSEABLE SUMIF(CHILDREN($[Payment Status]27),…
-
Resource View Filters
Anyone know how to add more than one filter to resource views... I want to see a Resource View of our Purchasing Group's users resources for all projects that contain "XYZ" or "ZYX"
-
Linking cells that are dependent
This is going to be a tough one to explain, and I'm not sure if it's possible. That said...: Endstate: For a finance-based sheet ("Sheet 1"), I want one of the values from a user's form (Amount USD) to populate in another sheet (Sheet 2"). Problem: There is a debiting manager (losing money) and crediting manager (gaining…
-
Adding Positive Parents
Hello all, I am trying to set a formula up that adds the sum of several Parent lines, but only if they are positive. Adding all parents under one banner i use the Sum(Children) however, I tried to add only positive parents by using a SumIf(Cell1:Cell5, >0, Cell1:Cell5) but in doing so only managed to add all positive…