-
Seeing user activity as an admin
I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time). Logs only shows me logons. I need to verify that licensed users are really using the product. I put a ticket into support a week ago but never heard back. Hopefully I can get a response here.…
-
Links are not working from published reports
Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached https’s server IP address could not be found. * Search Google for https goo maps…
-
Reports not updating accurately from linked Smartsheets
Smartsheet appears to be a little slow today in updating charts, reports, etc. and with accurate data. Wondering if this is an anomaly or if this is due to a more global impact from Cyber Monday.
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
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…