-
Many columns on sheet - not all appear as options in a report?
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'm trying to build, the 5 columns that I need to appear and provide data, are not showing up in the columns from which I can…
-
Card View - Conditional Formatting
Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry over to Card View...any ideas? See attachments Any help much appreciated, Jack
-
Calculating work completed and forecasts
I want the smartsheet to automatically update the “WIP (local)” column each month and reduce the current months forecast to £0. As you can see below, the “WIP (local)” column has increased and the forecast for September is £0 (this is fine). However, the smartsheet has now overestimated the total cost of the task (work…
-
Counting and Dividing Certain Cells
I want to divide the number of requests that were completed on time by the total amount of requests submitted that month. I'm referencing another sheet in my formula. The following is giving me "UNPARSEABLE" =IF({On Time?} = "Yes", {Submitted Date}, YEAR(@cell) = 2023, {Submitted Date}, MONTH(@cell) = 1) / ({Submitted…
-
INDEX/MATCH returning #NO MATCH error but only for ONE cell
I have the following formula checking for matching emails in two sheets & returning the date: =IF(Done@row = 1, INDEX({Submission Date}, MATCH([Email Address]@row, {Submission Email})), "") It's inside an IF statement because the Done column checks if there's a submission for the email in the first place--I only want the…
-
Duration Formula Help
Hello, I am trying to create two duration formulas. One is the duration is between request date and manager approval date and the other is the duration between manager approval date to admin approval date. All three of the date columns are the date column type. The date columns are filled in automatically by Workflows. I…
-
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},…
