-
Exporting Smartsheet calendar to Outlook 365
I'm struggling to export Smartsheet Information into Outlook 365 calendar. I'm trying to create a group calendar specific to resources(people) assigned to task(s) within my SmartSheet schedules so to have each individual assigned to a Smartsheet task in order to get an overall view of each persons time spend on multiple…
-
Does smartsheet have the ability to track a resource's time at a milestone level?
I am trying to see if this functionality exists or if this is an enhancement that can be created? This would allow the ability to report on specific activities instead of at a project level.
-
Automating Start Dates and End Dates within a Project Plan
Hello there! How do I automate or create formulas to predict start and end dates for a project plan / timeline in Grid view? We have four stages - Planning and 3 to 4 different Creative Asset delivery dates for 4 departments. Look forward to your guidance here!
-
Consolodating rows with the same primary column
My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order. So for example; if an order has 8 lines on it, it lists that order 8 times with the quantity of each line rather than showing…
-
Daily Reporting to Document Generation
Good Afternoon, Our construction firm utilizes a standard Gantt chart sheet to track our project's daily reports. Under each category of work we have milestones, i.e. Carpentry :: Framing :: Drywall etc. Under each milestone we add a child for that days work, i.e. Drywall :: Day 1 - Mobilized :: Day 2 - Started Hanging…
-
Does Smartsheet Support "Schedule Performance Index" (SPI)?
I've seen some past posts where users tried to create their own columns for this, but they seemed to have errors in the way the calculations were done. What is the latest solution from smartsheet (or recommendation from end-users) to have a calculation that works correctly for SPI? It should be SPI = Earned Value/Planned…
-
July 25, 2024 You can now manage filters in real-time in timeline view
Managing your data in timeline view just got a lot simpler with our new filter drawer! You can now easily view, create, edit, save, and share filters and see results side-by-side in real-time as you make changes. Plus, your filters persist across sessions, so you don’t have to set them up each time you log in. You can…
-
Formula to lookup a value based on start and end date
Hi All, I need your support on this case. I have a project to improve the current sales report layout and I need to extract the Vendor Support data for each item depend on the sales records, and the start and end date for this vendor support. Here is an example: Below is the table where I want to have the formula to…
-
Email address (mailto: link) in Dashboards
Hi - Have there been any updates on being able to enter an email address (mailto: link) in Dashboards. I would like to add Key Contacts for the project in a Rich Text Widget and include links to emails for those contacts. I've tried but have not been successful. Any possible workarounds? Thanks, Jan P
-
Formula Question
This is my current formula that is producing error - Unparseable, I can't seem to figure out what the issue is. =OR(IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row - 1,{Min_Skill_LTT}),"True", "False"),(IF(INDEX(MATCH([Job TItle]@row, {Minimum Skill…