-
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
-
Nested IF or MATCH or JOIN+MATCH ?
Dear Community, I am trying to retrieve the information of one cell depending on several criteria: - Match week number from a date with Week Column to retrieve the payment amount - Prioritize between 2 dates (though between 2 week numbers) which one will be retrieved (Actual Payment Week will have priority over Expected…
-
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"
