-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
-
Please add a display format that automatically appends +/▲ symbols to calculation results
Note: Translated by moderation since enhancement requests are currently only supported in English. Currently, Smartsheet offers display formats like “Currency” and “Comma Separated” for numbers. However, there is a need to display calculation results as follows: Requirement: We want the format to automatically append a “+”…
-
Please add Japanese-specific formats like “hundreds of millions” to the number display options
Note: Translated by moderation since enhancement requests are currently only supported in English. Currently, Smartsheet allows selecting formats like “currency,” “decimal,” and “comma-separated” for numbers. However, in Japanese business practices, amounts are often displayed in “hundreds of millions.” Request: Please add…
-
Dropdown Link is not working for me.
I am testing on this dropdown link but it is not working for me. 😣 I created both the source and destination sheet. Source sheet: text number or dropdown list column Destination sheet: dropdown list column After linking the dropdown list from destination sheet to the source sheet, the data is not showing in my destination…
-
Restrict Who Can Delete Sheets or create Verification Check before deletion
I recently had an unlicensed user with Admin permissions delete several sheets that I own. I was able to recover them since they fell into my deleted folder. Can this be restricted to only the owner can delete a sheet (I thought this is how it used to work?) Or can there be a notification set up to the sheet owner if…
-
Comments for Conditional Formatting
When creating conditional formatting, it would be helpful to have a Comments field where you could add context on what the formatting is indicating, and why it is doing it. This is helpful when you have multiple people that manage the conditional formatting. See the attached photo for a mock-up of this idea.
-
FolderResources.GetFolderChildren isn't returning the createdAt and modifiedAt for sheets
The new version of the api (FolderResources.GetFolderChildren) isn't returning correctly the createdAt and modifiedAt fields for sheets. As an examplle the following call isn't returing the fields correctly : SmartsheetClient.FolderResources.GetFolderChildren(9999, null, null, null, null, null, null); Can someone raise…
-
Quick Fill to Multiple Cells?
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
-
Merged: Line Banding
This discussion has been merged.