-
remove column ids, row ids from Smartsheet json!
hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks.
-
Connect MS Power Query to Smartsheet?
Can anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsheet via Power Query, but I’ve not been able to figure out how to access my content through Smartsheet and manage the data.…
-
Unexpected movement of rows
Hello, A sudden shift of rows happened while using smartsheet. The detail is as follows: Three people worked on a same spreadsheet. One was changing the arrangement of rows, such as shifting row 2 below to row 5, while other two were inputing data in some cells. Then, suddenly some data appeared in rows where no one input…
-
Any workaround if database exceeds 5000 rows and need vlookup function from other sheets
If I need a database page where other sheets can pull information from it, to standardise data input, but having the following criteria/situation: 1) database page will keep information for 1 year (database = employee data) 2) will exceeds 5000 rows / 25,000 cells within the 1 year duration 3) cannot move row away as other…
-
clone filters from one sheet to another
Hi, I set up 5 filters in one sheet. I have 20 more sheets with the same columnar structure. I want to "clone" the 5 filters into all the 20 sheets. I don't want to do it manually. I don't want to do the "Save As New" because the 20 sheets have been established already. How can I do it? Thanks, Shinya
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
Set default text for a given cell
I am creating a template and would like certain cells to give an example or show what type of information should be entered. The default text should be in that cell always unless other text is entered in. If the newly entered text is deleted, the default text would show up again. In doing some research, this type of field…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Cell linking
What am I doing wrong? I am linking cells from one sheet to another. When I do so I select two cells and then link them to two cells in another sheet. However, only the first cell has a link not the adjacent one? Also when I delete the link and go to try again the deleted link still appears in the source sheet.
-
Problem in taking the weekof as Wednesday
I want Wednesday as the weekof based on the date for e.g. If cell A has date of 25th Nov, the weekof in cell B for that date should be 20th Nov If cell A has date of 27th Nov, the weekof in cell B for that should be 27th Nov If cell A has date of 26th Nov, the weekof in cell B for that should be 20th Nov What would be the…