-
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…
-
Creating a Form to Automatically Indent Tasks Under Projects in Smartsheet
I am working on a project tracker in Smartsheet and need help setting up a form that allows users to add tasks under specific projects. My main challenge is ensuring that these tasks are automatically associated with their respective main projects and indented correctly I'm struggling with the automation part.…
-
Do more with timeline: display full bar titles, see collaborators & support for single-date sheets
Hi Community, We are continuing on our journey to optimize timeline view and are back with a flurry of good news! You can now create timelines in sheets with just one date column, customize how bar titles are truncated to best suit your needs, and see who is collaborating with you on your sheet. These awesome features give…
-
Purchase Order creation and management
Hi, we are a small residential building company based in Australia. We have a workspace that we use to manage all of our projects that includes pretty much everything expcept for purchase orders. We currently have a BOQ with pricing, but i am looking to turn this sheet into individual orders. Wondering if anyone uses…
