-
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…
-
purpose build bar-code Scanners + Smartsheet
Can anyone recommend a purpose-built portable device for scanning barcodes that could be used with the SmartSheet (i.e. not a smartphone or tablet)? We're looking for something we can use in a laboratory environment, so it should be fairly rugged, have good battery life and be designed for barcode-reading applications. Any…
-
The Mythological Product Development Team
Once again, I have gone in search of what I would consider a perfectly logical and necessary function only to find that Smartsheet can't accommodate. When I call customer service, I receive the same answer every time: “We don’t currently offer that function, but we will submit this to our product development team and they…
-
Can a smartsheet form autopopulate a PDF? Or can you push every row to a recreation of the form (in
Hi, We are using forms to gather group ideas for creative projects. After, we would like to take each form submission or row and populate to a formatted PDF that can be presented to the managers for approval. Is there a way to push a form submission to populate a PDF? Or link cells in smartsheet to a PDF? Or any other…
