-
Have Header Row Sum All Items Within Same Column
I've been trying a few different things to see if I can get this to work and unfortunately I'm having a hard time. Right now, I have a resourcing sheet that has header rows for each team member and each week has it's own column. Every task needs to have the number of hours entered per week for the work effort. Because of…
-
Data Shuttle does not import times from excel correctly
Hello, We have an excel sheet that has a Start time and stop time for tracking how long items took. However, when we use the Data Shuttle, SmartSheet converts the time to a date. How can we keep this in a Time format ( 8:00 am)? This is a critical part of our playbook with clients, and we need Smartsheet to be able to…
-
Auto Create Child Rows from Dropdown; how to get array values to auto populate each child row
Hello :) I am building a project management system where we have: Asset (Parent Object) Components needing fixing/replacement (Child Objects). In my Bridge workflow I have managed to achieve child row creation based on the number of values in the dropdown cell (components). I need to add a feature that spreads each…
-
Recurring Tasks - Please.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.…
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the…
-
ERROR ESPACIO DE TRABAJO
NO PUEDO ACCEDER A MI ESPACIO DE TRABAJO ME MARCA ERROR
-
Project Schedule Question
I'm looking to make adjustments to my current project schedule. Currently I have an asset due date milestone, a list of tasks with durations and predecessors and a go live date milestone. I am able to put in the partners desired go live date and the formula deducts 6 weeks to determine the asset due date. We are making it…
-
"Live" source template sheet
We have projects running with long and complex workflows and thousands of tasks - so we need to break these down into multiple sheets (dozens), and then use reports to extract data from tasklits to time-tracking and budget burndown. However - if we need to change the structure or components of the sheet in any way ( extra…
-
Formula Help Extracting Month Only from Formula Driven Column
Hi all- I need help trying to extract the month number from another column. My 'Notification Date' column uses a formula (based on the service 'Type') to calculate a specific timeframe. I need to extract only the month from this 'Notification Date' and populate it in the 'Annual Review Month #' column. I was good until I…
-
Microsoft Causing Issues?
Hello, my company uses Microsoft office, so outlook is our email platform. Is that why my auto emails aren't sending from my smartsheet? I have them on my registration page, I click "ready to send" then save and it's supposed to auto send the invite/start the registration process. It's been working all week and last week…