-
Creating new sheet using Java API - Unable to create child tasks
I am trying to create a smartsheet using Java API that fills data in parent/child task format. I tried couple of options, but I was getting exception. I am not sure if it is possible. So, I tried another option, where I created the sheet and then re-read the sheet and tried to indent the rows using following code - //…
-
Have User Filing Out Form Include Clickable Hyperlink
Hello, I am trying to see if there is a way to have someone completing a form to be able to include a hyperlink to where a file is. It would then come onto the Smartsheet so someone else could click on the link to get to the file in a shared drive. Many of the files we work with are too large for attachments and a…
-
Can smartsheet auto-populate cells based on the above cells in a column like excel does?
Can smartsheet auto-populate cells based on the above cells in a column like excel do? When completing text cells the system doesn't indicate that text word is already above? This is useful not to duplicate like currently, excel can do it by default. Any idea if this is possible or can be enabled would be appreciated.
-
JIRA Sub-Tasks remaining estimates do not roll up in main task in Smartsheet
Hi. I have a JIRA project that is comprised of tasks and sub-tasks. The sub-tasks have remaining estimates that sum up at the task level. For example, if I have 3 sub-tasks that have respectively 1, 2, and 3 days left are shown as 6 days remaining at the task level. I sync it with Smartsheet, and I use the Remaining Time…
-
card view filter - include summary tasks
I commonly have task lists that are nested to an arbitrary number of levels. In card view, you can filter tasks to level 1, level 2, etc. This isn't very useful to me. I think it would be far more useful to have a filter "include summary tasks (or not)". Since my actual tasks are always on leaf nodes of the hierarchy, by…
-
Symbols that could migrate to excel
Hi all, I need to export a smartsheet file to Excel. The thing is that if I use for the status and legends, pictures (.png/.jpg), in the excel I don´t get the images, I get their labels into that column. So do you know if I use symbols instead of pictures, if I am going to be able to see the graphic symbol also in excel?…
-
Rounding Down a Start Date
Hi, I'm seeking to round down a start date so it begins at the beginning of that day. Within my project plan, there are a number of partial day tasks (0.25d, 0.50d) that influence the successors, resulting in "Start Dates" being midday. I'd like to round down the start date so that a simple 1.0d duration starts and…
-
header formatting
Is it possible to adjust the formatting on the headers (e.g., make headers bold or centered without changing rows below?)
-
Export User Group List
Hello, I am having issues exporting a list of all my contacts within a specific group. Under the group management tab, there is no good way to export a list of everyone within a specific group. Anyone know how to make this happen? We have hundreds of users within one group and we want to pull that list. Thanks!
-
Smartsheet and Google Docs Merge
Hi I'm trying to add on Smartsheet Merge to Google Docs and keep getting the same error message ScriptError: Authorization is required to perform that action. Extremely frustrating as the Google Account accepts the link but unable to proceed further? Can anyone help with this please Y
