-
Values not appearing in linked Excel table
I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. I have another, very…
-
Repetitive Task List Instantiation - Editing Multiple Tasks From a Master List
A common experience we encounter is when we have long, identical lists of tasks (7 or more), indented under many parent titles, that need editing, as shown below: PARENT ONE * Task ONE * Task TWO * Task THREE. etc. * PARENT TWO * Task ONE * Task TWO * Task THREE. etc. We have many PARENTS with identical lists of tasks that…
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
POST request to fill a column with type PICKLIST
I'm using php-curl to add rows to a sheet throught POST requests and it works good to fill all the text fields. But when I try to add data for a column that has PICKLIST as type it won't work. So this is how the column is structured. { "locked" : true, "type" : "PICKLIST", "index" : 5, "title" : "Severity", "lockedForUser"…
-
Accessing HomeRessource of specific Users via JavaSDK
Hi there! I'm developing a statistic tool for monitoring file creations with smartsheet in my company. First of all, thanks for the brilliant Java SDK, that makes live so much easier when trying to integrate Smartsheet in other applications! Currently I'm at the point where i have to access every user's home directory, to…
-
Opening Worksheet in New Browser Tab
When navigating through and opening several sheets, it would be helpful if there was the ability to right-click on a SmartSheet and open a sheet in a new browser tab. Currently we have to open a new browser tab, navigate to smartsheets, then find/open the sheet.
-
Counting rows with multiple drop-down options
Hello, I would like to count all the rows on a sheet that meets certain criteria. The sheet has a column [Project Status] with the following drop down items: Tentative Confirmed In Process Delayed On Hold Punch List Completed Cancelled RMA Processing I would like to get a total count of all the rows that have open…
-
How do i share a sheet with the community?
Hi Team, I saw an answer to a comment by one of the community members on here who shared a sheet with a link. By the looks it was a dummy sheet that you could click on cells and see the formulas etc. I have five sheets I use with personal customer’s information, i have set up a dummy sheet i want to share with the…
-
VLOOKUP, ISNA, IF Statement
Hi! I would like to know is this kind of formula available in smartsheet? =IF(ISNA(VLOOKUP(C2;I:I;1;FALSE));"NO";"YES") In short- If there is the same name in other collumn mark YES Thnak you!
-
Enhancement Request: Filter for attachments
When viewing the attachments attached at the sheet or workspace level, it would be useful to filter for ONLY the attachments at that level. In the screenshot below, all Row attachments are visible, but I'm only interested (for this search) in the ones that are attached to the sheet. Similar functionality already exists for…