-
Inventory Management (relationship workaround)
Hi, I haven't actually started this in Smartsheet because I don't know where to start. I have an inventory list (excel) that itemizes on multiple rows against one PO#. Like this: Line 1. PO# 12345 Item: Desk Qty 5 Line 2. PO# 12345 Item: Table Qty 4 Line 3. PO# 55555 Item: Chair Qty 3 I am trying to see how I can get that…
-
Align column order in grid view...
I've duplicated the same sheet to contain completed project rows according to fiscal year. I've needed to change the order of the columns in one of the sheets and would like that same order matched to the other sheets. If this is possible, how? This is in grid view.
-
Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
-
IF Formula with Multiple Criteria
Hello! I have a software enhancement sheet, and I am trying assign priority to each enhancement based on the level of effort (LOE) + change priority calculated score. The LOE can be one of the following: 1 - Unknown, 2 - High, 3 - Medium, 4 - Low, 5 - None The change score change range from 4-25 The breakdown for priority…
-
Overall Project Status based on frequency?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
How do I enter Contact List details into a Form?
I want to be able to enter the Name and Email Address components into a Contact List column type field on a form. Is there any way to do this? Or even to create a formula in the Sheet that will calculate the Contact List value with display Name AND Email Address, not just one of the other. Otherwise, please Smartsheet, can…
-
Help with a formula to count how many projects with a brand have the status of "approved"
Hi there, I'm trying to figure out how I can count the number of projects for a brand have a specific status out of the total projects for that brand. Also, I'm referencing a different sheet for these formulas. I already have the formula to count how many projects are associated with a specific brand, but now I want to set…
-
Getting timeout when moving large rows manually to another sheet
Hi there, I have a setup where I have a sheet. I need to import Excel data to this sheet weekly. The sheet and the Excel file have the exact same column names. The data has 145 columns and around 450 rows. Because I can't import directly to the sheet, I tried using copy paste. But, I run into the column limitation that…
-
Suppress "Quick Update" prefix from populating when manually sending row
Is it possible to suppress the "Quick Update:" prefix from populating when manually sending a row? The subject line keys off of the Primary column, which is great because we can codify pieces of row data via formula but we don't want this extra language.
-
Enhancement Request: Workspace / Sheet level Attachments / Discussions
I have submitted this before, not posted to the Community. Still a pain point. I'd like you to revisit the functionality around Attachments and Discussions at the Sheet level and Workspace level. Back in the Good Ol' Days (pre UX update 2018-02-13), we could see that there were Attachments or Discussions at the various…
