Hello I have an existing excel which does the below job using pivot table. For each project iCode, for each RFC if we have same PO and same line item then we are adding the cost. Hence for the first 2 lines we are adding. Again for line 4&5 we are adding the cost. And we are putting this into a different excel. Also we are…
Is there any way to see what data on a sheet has been updated/modified after a datauploader run?
I'm looking for some help setting up my integration from Azure DevOps to Smartsheet. Anyone have experience with that integration?
Hello, If I set up a Data Mesh on Sheet A and then create a copy of Sheet A by doing "save as new", will the Data Mesh target remain on Sheet A only? Or will it now target Sheet A and Sheet B? Would it be better to use an Index/Match formula on Sheet A in order to have it carry forward onto Sheet B, C, D, etc.? I suspect…
I was trying out DataMesh for the first time and ended up getting the following Error message: Error code: 500! undefined method `[]' for nil:NilClass As it is very non-descriptive, I have absolutely no idea what I did wrong. Has anyone else experienced this error message and if yes, could you fix it?
I have enabled proofing in my sheet and see the option for it in grid view, but when in card view I don't see how to submit a proof. I couldn't find any answers online and wanted to see if I was missing it! Thank you.
Hey! I created a Pivot that will be updated daily (source data changes daily). When I set up the pivot, the name of the columns is like this: "AMS-CNT-Test Instance ID", since I am applying a count of "Test Instance ID". However, for reporting purposes I would like the column to be named simply "AMS" so when doing a chart…
Hi Community, I thought i had my filters set up correctly, see screen shots of those color systems below, but my calendar doesn't reflect that (see below for screen shots of calendar and settings). The items showing in the calendar should appear Magenta but are not. Help!
Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each row I need copied into the existing spreadsheet has a Parent Row (a number) and a Child…
I am tasked to show all active rows from a sheet in a Smartsheet form where users can select which one they want to de-activate and provide business reasons and justifications. Is this possible?
I have reports generated from a sheet where sheets attachments feature Google Docs/Smartsheet Merge Add On. I am not seeing the attachments in the report. Is this to be expected? Thank you! Lisa