-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
How to get automatically an average data based on date rage on a daily basis
We are using form to create performane data per robot per run ( input can be few times a day) I need to start measuring daily avereage for their performance seperately (1 called North 1 called South) but can't figure out formula for it and then I'm assuming creating a chart would be straightforward? but not done it before…
-
Linked cell won't show currency format
Hi, Please see below. Some linked cells are showing currency format while other cells are not. Current setup: Source sheet (linked from)- numbers are all set to currency format with column properties set to "text/number" This current sheet (linked to) - all columns proporties are set to "Date" with "restricted to dates…
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…
-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
Is there a revised formula that will allow me to show more accurate training dates?
I have a formula in a training matrix that compares dates of when a document revises and when the training was carried out for employees. =IF([Revision Date]@row > [employee]93, true, false) However, this returns a red font date if the revision date is greater than the training date, even if the employee was trained prior…
-
Hyphens between combined cell data when not blank
Hi, I have the below formula to combine a number of cells together to make a naming convention. I want hyphens between each piece of information but only if the cell is not blank. We only have a Program Code 2 about half the time, I don't want an extra hyphen in there when it's a blank cell. The combined data at the moment…
-
Remove BLANK in PIVOT TABLE
How to remove BLANK values in Pivot sheet. The source sheet is having a default rows, but I am maintaining limited rows and rest of the blank rows are reflecting in Pivot sheet. How do I remove ?
-
Cell-link: Duration and Start Date - End date isn't same
Hello Community people, I have same duration and Start (date) in 2 sheets, which linking is set. But End date gets different. Dependency settings (Working Days and other items there) are exactly same. Start . End . Duration Original sheet 5/7/18 5/6/19 260d Linked sheet 5/7/18 5/3/19 260d This task does not have…
-
Formula Help
Hello, I recently used this =SUMIFS formula and now that I have changed some VLOOKUPS the formula gives me a #NO MATCH error. SUMIFS([Request Total]:[Request Total], [Employee ID]:[Employee ID], [Employee ID]@row, Date:Date, <=Date@row, Date:Date, >=DATE(2022, 7, 1), [Department Approval]:[Department Approval], "Approved")…
