-
Reference Cells That Start With Specific Numbers
I would like to write a COUNTIFS statement that will count the number of cells that begin with certain numbers in a column. The goal for this is to be able to count cells that are between certain times of day, so I would like it to be able count the cells that begin with "1:, 2:, 3:, 4:, 5:" and a separate one for other…
-
Reference a column in another sheet
Hello - My company is new to smartsheets but it has ALREADY made a huge difference for us. I'm playing with functions that reference other sheets and I have a very specific question - I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same. The formula I'm working looks…
-
Linking Epics Across Sprints
Hello Community, I'm trying to rollup epics and themes that exist across multiple Sprints in my smartsheet. I've created parent and child relationships from a Phase level. I may have my parent-child relationships incorrect. Please take a look at my screenshot. Any help would be much appreciated. I'm trying to roll up %…
-
Building custom actions
I need to continue some training in setting up actions from one sheet to another. I can use the pro-desk to set up a 30 minute training session but can't remember how to get the code to type in for a new request. Thanks, Dennis
-
Sum of work log between a date range for given list of users
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all users. I tried summits but not able to come up with anything as it is always giving mw wither 0 or invalid argument. I tried…
-
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…
-
Contact Columns marked Multiple Don't Populate Legacy Reports
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though…
-
Dashboard Color
Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
-
More Robust and Complete Backup Solution
Hi there, Are there plans to offer a more robust backup solution for sheets? We are using the Command-line backup java utility (aka Backup Tool), and that works alright, but it’s not a true backup solution, as files cannot always be simply re-loaded back into Smartsheet have things be “just the way they were” when data…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
