-
Workflow question
Hello Experts I have a requirement where I need to create new row in child sheet if new rows are added in the master sheet. I also have the requirement that if any of the fields gets changed in the master sheet that should be reflected in child sheet. Is it achievable using workflow? Thanks for your help.
-
Pivot functionality of smartsheet
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…
-
Automating the Correct Start and End Date within Control Center Project
When creating a project in Control Center, when the project is spun up and moved from our Intake Form/Sheet to Project Generation (On the Active project Sheet). The Control Center system is automatically putting in a random date every time a project is created. These dates are put in on every project we create. I went…
-
Locking in Colors for Charts in Dashboards (Avoiding category colors changing with dynamic data)
Hi, I am having an issue with Pie charts changing colors when data in the underlying sheets is altered. For example. If I have a pie chart with categories for task status: Not Started, In Progress, and Completed. Lets say I designate those colors Red, Yellow, and Green in the Pie Chart. If the underlying data changes so…
-
Adobe XD examples
Hi all, I've been trying to see if there are any examples on Adobe XD integration into a Smartsheet dashboard via web content. I understand that Adobe XD is a tool that people use for web design and such but I am having trouble finding examples on how people are utilizing it. My current impression is that it can be used as…
-
Using Data Mesh on Template Sheet
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…
-
How to see what row data has been updated with datauploader?
Is there any way to see what data on a sheet has been updated/modified after a datauploader run?
-
Changing names of Pivot Table columns
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…
-
Datamesh - way to transfer only parent row to sheet?
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…
-
Not allowing me to share Dynamic View
Hello, I am trying to add people under shared users but it only only has a limited number of names and it wont let me add in any outside of that list. What could be causing this? Thank you
