Comments
-
@Andrée Starå referred me here, I am assuming this same functionality can be done on Sage 50? Or has anyone ever tried? The company I work for, when I first started, assumed that Sage and Smartsheet "couldn't talk". Meaning, we could not link the two databases together. What I am finding is that may not be the case with an…
-
Thanks for the response, Craig I do not believe index/match will do it- maybe I am wrong! However, I have a pic for an example. The part you see is my "Roll-up" section of the dashboard. The left hand column is the criteria to be accumulated weekly, rolling left to right. So, lets say I create a cell reference from 3…
-
I would prefer to not use another app, I think filters are probably my best option. What recommendations do you have as far as filters?
-
I figured the problem out. Each rows primary key (I think it is called), was assigned to a job number. Ex. 17-567. The total row, at the bottoms of each sheet, did not have a job number applied to it. So, I had to make up a random job number for the total row for it to transfer over correctly. Thank you for your assistance!
-
Yeah I sure did, the only thing I can come up with is that Smartsheet is having a problem with the formulas. My goal would to have 3 different sum/total rows, and I don't think it is working well with that.
-
Top is Excel and bottom is Smartsheet
-
I can only share a limited amount of information, I hope this is enough. What do you specifically need to see?
-
I checked and I do not, I will be posting a screen shot of what I have.
