-
Another Thank You: Lessons Learned
I really appreciate this (from status.smartsheet.com) Craig
-
Identifying Main tasks & Sub tasks / Identifying last child nodes in hierarchy
Hi All, I'm new to Smartsheet. I would like to know how could I get to know a task is a Main task or Sub task using Smartsheet APIs, My requirement is to consider all the Subtasks (Child rows) in a smartsheet for some calculation purpose. When I see a smartsheet, I can do indentation and I can recognise which is Main task…
-
I cannot manually re-open manually collapsed columns.
I have collapsed a few columns manually by dragging its header row borders but are now unable to open them back up. Even if I use my browser zoom button to precisely select the border the double arrow cursor will only select either column to the left or right of all the manually collapsed columns. I can verify the columns…
-
Commenting your code
Where do you comment your code? When working on a big sheet that you may have to come back to months from now, or a system of sheets you are working on with other Admins, how do you document code 'inline'? Hidden columns? Attachments? What have you found successful?
-
Webforms | Survey - Customizing Column Headers or Question Content
I currently use an external tool to conduct 200-300 surveys and collect data on project performance for my org annually. Data is exported from the tool and compiled in excel. I want to transition to SmartSheet to alleviate the manual survey creation and lift and shift of data. Problem: Each survey is customized listing a…
-
Data connector cell version information
Howdy, We are looking at attempting to do timelapse analysis (velocity, etc) with the SmartSheets Data Connector through Tableau. There are instructions on how to connect to the table for your sheet data; however, I am unable to locate anything that details how to connect to the cell version information to do time lapse.…
-
Send Update Request via API to Contact List User
Has anybody deveoped a solution using the API's to send Update Request from a sheet? Meeting with my developer to see if we can send an update request when the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup…
-
Project sheet start/finish dates
Hi all, Pretty much all my projects work over weekends. I am trying to set deadlines for start or finishes that land on either a Saturday or a Sunday, however, the project template keeps defaulting the dates back to the Friday. Any suggestions? Cheers
-
Notification only when their name appears
We have A LOT of data we use smartsheet for and it is easy to miss something with our collaborators. I would like to be able to set notifications only when their name is assigned something and not when the entire column of "assigned" changes. Any way to do this?
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
