-
Live Tracking User Metrics Using Power BI
Hello smartsheet Community, I want to track company smartsheet user metrics such as the number of users, number of sheets, user types, etc. automatically using Power BI. Currently, I am exporting the user and sheet access reports and having to combine them into a single view before displaying the data in a meaningful way.…
-
[PYTHON API] Adding an new row with date column
Using the python SDK, I'm having trouble adding a new row to a sheet where one of the columns is a DATE column. For ex, doing: cell.value = datetime.datetime.now() with the column type as DATE doesn't assign anything to the column, and the request comes back with an error since the cell.value is empty. If online I switch…
-
LastLogin is Null when pulled through Smartsheet API
I'm using C#. After authenticating, the following code returns null for all LastLogins. It works for other fields I'm pulling such as Id, Name, Email, SheetsOwned, etc. Is there an issue with that particular field coming through the API? Since it is a date field, does it need to be treated differently, though I am only…
-
New Comments window
The other day our comments pop up box went to the classic pop up square box in the middle of the page to a slide out from the left side. Terrible Idea now it cover a third of the page and I am constantly opening and closing to see the date behind it . The pop up box was better because it could be moved around the page to…
-
Send - Function/Option
i was really hoping this was not going to happen. I have worksheets set up (at 14 facilities) to be able to "send" the row to themselves and then to the customer. I REALLY need this function back. I need users to be able to do this.
-
Data Loader Expression Input value
I am receiving a MS project file in an excel format and trying to load into a Project sheet in Smartsheet. I have a WBS column and from the WBS column by counting the dots I want to determine the level. The formula works fine in a sheet but when I write the formula on the expression input value as =LEN(WBS) -…
-
Toggle Hyperlinks
I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., tim@ourcompany.com) or external (i.e., one of our customers - e.g., bill@clientcompany.com). Is there a way to do that via a…
-
Move row API not working
We use move row API since 12 hours ago it has stopped working
-
Auto fill information in sheet when a check box is checked in a different sheet
Hello All! I am trying to figure out how to auto fill information into my sheet, when I check a box in a different sheet. I am keeping track of different invoices and sponsorships in the original sheet. When I check a box in the column "Ad" then I want the "Organization", "Event", "Start", and "Due" columns to auto fill in…
-
cell.format currency settings
I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the cell.format that works for submitting 123456 as the value/display value and a…
