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…
Good morning, I have attempted to search the answer but not having much luck. My question is: The team I am apart of currently use Outlook calendars to record the various event sessions taking place throughout the day in different rooms. We have begun using Smartsheet to record the events so we can display the statistical…
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
Is it just me, or are you unable to filter based on a column with a column formula in it?
Help shape the future of Smartsheet. Share your ideas and feature requests.
