Dynamic View - Calendar
Hi - am trying to set up a Dynamic view of a sheet where only the Assigned to can view. That is complete. However, they do not have the option to change it to a Gnatt, Card or Calendar view. How can I do that?
DataMesh for Parent row value?
I have a task sheet with a column called Team (for the team doing the task) plus a column called Task for the task. For each task, teams create subtasks. For the Subtasks, I would like the "Team" column value for the subtask row to be autopopulated based on the Team value of the Parent row. In the screenshot below, desired…
Dynamic View Access
Hello, I am doing some consulting work, I really familiar with dynamic views from my full time work. However, I don't quite understand how access would work if I am using my free, personal account. Will a user who requires dynamic views in their setup need to add me to their account so I have the dynamic view app? Or will…
Control Centre: new profile data is not cell-linking in the summary sheet
I have added 3 data sets via global updates, the columns appeared in my summary sheet automatically as usual but the data itself isn't auto cell-linking like it has previously. I have made sure the column types are dates as all the data is a date. I have removed all column formulas from the summary sheet as requested. I…
Control Centre - Batch Updating
I am about to launch my first control centre Blueprint and one thing I am wondering is what would be a best practice for recording notes at a program level. We have a status meeting that reviews the projects in the Blueprint Summary.. The client will pass on a tidbit of knowledge in the meeting and we will record a note..…
When I upload a smaller file to my Data Table will it remove the old data if it exceeds the new?
Hello,, I'm figuring out data tables slowly and a question I have is if i upload a csv with 200k rows to my data table, then i turn around and upload the same file but it only has 150k rows, will it delete the extra 50k? thanks, Spencer
Parent Child Relation in Dynamic View
I was wondering if there was a way to display the parent child hierarchy the same way it is shown on the main sheet with just the data on the dynamic view of the sheet? I have a dynamic view where all completed and cancelled status projects show up, and would like them parent/child to be displayed as it is on the main…
Can Power Apps use the Smartsheet connector to update cell values in a Smartsheet?
I wrote a Power App that accesses the data in Smartsheet cells. A Smartsheet contains a table full of Rows. And each record in that table includes some data and then a table with the custom columns/cells. So you can't just connect to a Smartsheet. Instead, I loop through the Smartsheet and build a local collection that…
Data Shuttle Offloading Wrong Data?
Hello, I have a main data source which collects project information from different vendors. Figure 1. Example of main sheet row To work with outside vendors, we have public facing sheets that we offload data to using data shuttle. Figure 2. Data Shuttle Offload Criteria This data is then uploaded to the company's sheet…
Mass Transfer of Ownership of Dynamic Views
Hello, I need to transfer ownership of a number of Dynamic Views from myself to someone else. The issue is that I have over 400 views. Is there a way to do a mass transfer so I don't have to go into every view and manually transfer ownership?