-
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
-
Adding a Primary Column
Hi. Ive just signed up for the free trial as I have a live project and I need something like Smartsheet. I can't seen to work out how to create a new Primary Column. What do I do ? Thanks..
-
Help with nesting, please?
Hello, I am a beginner... Would anybody help me to nest this formulas? They work independently but when I try to integrate them, I cannot make them work. Maybe is not the right formula for what I want to do. I have a symbol column that should apper Red("No") or Green ("Yes"), conditioned by different combinatios of four…
-
Multiple Installation Dates to show on Calendar
Hi, I'm trying to schedule 2 dates form the same line into a calendar. For example. Each time we sell a job, the job has a Part A installation, and a Part B installation. With this the line would have Part A Date, Duration and a installer. Same with Part B. The Installer is conditional formatted as a colour to show up in…
