This discussion was created from comments split from: Pivot App Zero Values.
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?
I need to create a Spreadsheet/report/calendar of team members who are free/unassigned to projects on each day. Most of our projects are events that take place on certain days and we often need to figure out if we can accept requests based on team availability. Currently, we manually check each team member per day but with…
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…
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.
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…
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…
I am trying to set up a new data uploader routine and when I get to the "mapping" section, it pulls up a blank page.
Hello, Some of our Smartsheet users are getting the error below when they tried to use the Smartsheet Merge extension with Google Docs. It appears to only affect newer users. We have other users who have been using it for a while and it still works fine. I tried to do it and got the same error. Any idea how to fix this? Is…
I am needing to import an excel sheet into Smartsheet with 10+ tabs at least 16383 columns. There are imbedded formulas referencing different sheets in the excel. Is there a way to go about this rather than importing one of the tabs at a time, and manually rewriting a lot of the formulas?
We have a few workflows where 11 fields are setup to synch between Smartsheet & Jira. The fields synching correctly include: Issue Key, Summary, Type, Status, Priority, Label, Start & Stop dates. However, the "Assigned to" (contacts, unrestricted) and a "Trend Start Date" & "Due Date" (both are date field, unrestricted)…
Help shape the future of Smartsheet. Share your ideas and feature requests.