-
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…
-
Re-occuring "Row" event reminder
Allow a row reminder to be set to repeat, I.e., every 3rd Thursday, every Sept 1st, etc.… over a more extended period vs. one at a time and having to recreate it. The current process is a more involved task of creating a workflow and setting conditions for EVERY row that needs a reoccurrence.
-
Printing across multiple pages - Gannt chart
When printing across two pages, can I repeat the columns with task, duration, start and end date, etc on each page.
-
Average Collect Issues
Hello! I'm trying to write a formula that will average the amount of time a type of request takes to complete by month. I'm referencing another sheet in this formula and just can't get it to work. Here's what I have so far: =AVG(COLLECT{Hours to Complete}, ISNUMBER(@cell), {Request Type}, "Quote Request", {Submitted Date},…
-
Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Is there a way to optimize drop down menus?
hello i am trying to have certain values only show when someone chooses one value. here's an example: Entity 1 Entity 2 Entity 3 Now based on those three entity there would be a seperate drop down menu with 10 items: Item 1 item 2 item 3 item 4 Ext... But if i choose entity 1 then only item 2 and 7 show but if i choose…
-
Can a Display Message be Created When a Report Has No Data to Report on for the Week?
Hello, I created a Report regarding issues that need to be escalated to leadership. I was able to link the report up to our folder and get data to run through the report to show what I needs to be reported on. Since there are weeks when issues will not require escalation and the report appears blank, I am looking to have a…
-
Add Comment Section to a form
Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.
-
How can I sum all the values of a column of "hours"?
hi everyone, I'd a issue with "time sum" that i need to converting to decimal after sum as you can see in the picture below. Is possible do a time sum without converting to decimal? @Paul Newcome do u mind help me with this quest? i really appreciate any help.
