Product questions?
Ask it here! The community's got your back.
Discussion List
Zero Values in Pivot App
This discussion was created from comments split from: Pivot App Zero Values.
Data Mesh
I am successful in creating data mesh configuration. would like to know how to configure multiple columns from same sheet in one data mesh config?
ENHANCEMENT REQUEST FOR DATAMESH and PIVOT
Please develop the ability to share Pivot and Datamesh configs. It is difficult for me to support my users when I cannot access their Pivot and Datamesh configs. Also, it makes it more convenient in training users when they can see what I built as examples. I realize I can transfer the config, but that is not always the…
Return last workday
Hi, I'm trying to create a report that will display the items for the previous work day. I initially tried creating a helper column with the following formula =IF(Date@row = TODAY(-1), 1, 0) which works great for Tuesday through Friday but on Mondays, it returns for Sunday. Is there a way to have it return the last weekday…
Multi-select fields via the jira connector, status on this being released?
Back in December I had a meeting with the Pro Desk, and one of the items we talked about was the multi-select mapping with Jira Multi-select fields via Jira Connector. I was informed that the Product and Dev Team where working on support this as the new column type was released back in October 2019. Can you please supply…
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…