-
Secondary Axis in the Graph
Hello All, I'm trying to create a two axis graph like primary and secondary axis but unable to change the elements to secondary axis (See the screenshot, I wanted to show the cumulative in the secondary axis, can anyone help me out.
-
Auto populate a cell when inserting a new row
Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible. Thanks in…
-
*NEW: Proofing using Reports
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design requests via Reports so that they only see what tasks and designs are assigned to them.…
-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Why Can't Column Labels be Bolded and Centered?
I read a previous answers on this which simply said, you can't. Why? I would like to know why we can't have this simple function which would make sheets look so much nicer and cleaner. Seems like a simple request to me...
-
Order Pipeline Model template
I'm a Smart Sheet noob and as I was watching the first Card View video I saw the Sprockets Sample which was referred to as an "Order Pipeline Model". This is very close to what I need to track our large orders of partially machine goods form overseas through ocean freight and in-house manufacturing processes. Is there a…
-
Calculating Duration based on Effort and Resource Allocation %
Why has product development ignored the need of real project managers to be able to calculate durations based on task effort and resource allocation percentages? This is one of the most basic needs of a project management tool and SS's response that 70% of PMs say this functionality is not needed is fatuous at best. These…