-
Clarification regarding Average(collect)?
I'm trying to calculate the average lifespan for a specific machine in a specific area, but am running into an issue with my average(collect) formula. Here's the formula I have right now, and it only returns as unparseable. =AVERAGE(COLLECT({Lifespan},{Machine},"1",{Row},"1",{Position},"1")) In this instance, its to…
-
Pulling Parent/Ancestor info depending on row hierarchy
I'm trying to have a column (Dept Helper) auto fill based on one Ancestor cell in another column (Department). I have a helper column (APC) keeping track of the hierarchy already (Ancestor = 0-Anc, Parent=1-Par, Child=2-Chi). I only want the Dept Helper to fill-in rows that are not the header row (Ancestor). Here is the…
-
How do I create an automation that ignores certain calendar days?
I created an automation in which I inserted 3 columns with dates in this way: Column 1: date A Column 2: date A +3 days Column 3: date A +5 days The problem: I would like the automation to ignore weekends and public holidays (of the Italian calendar). But I don't know how to do it, does anyone have a solution? 😊
-
Workflow for After Hours Tickets
Hi all, I currently manage our support tickets smartsheet and live on east coast. I have a team member who lives on West Coast and I want to create a workflow to have any tickets submitted between the hours of 5pm EST and 8PM EST sent to him with a notification. Currently, I am capturing the date/time ticket is submitted…
-
I think I need an index match formula as source sheet is unsorted
Hi, people smarter than me. I have been trying for days and days to get a formula to work. The source data is not sorted; it is populated by form data. The vloopup formula only duplicated the same result from the first row over again. =IF(VLOOKUP([Primary Column]@row, {2024 Circulation File Num to Support Level}, 1, false)…
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…
-
Incorrect Argument Set error when using Vlookup to reference another sheet.
I am using a Vlookup to use a row id in sheet A to lookup the corresponding row id in sheet B and return the value in the status column - the syntax looks correct to me but I am getting an Incorrect Argument Set error. This is the syntax I am using: =VLOOKUP([Row ID]@row, {Cutover Tasks Range - Row ID}, 6, false) Can you…
-
Counting formula-checked check boxes in sheet summary column - returns Invalid Data type
Hello, I am working on a project that is counting checked checkboxes that are checked via a column formula. I have tried changing to a COLLECT and a VALUE function but neither seem to work. Summary Formula currently: =COUNTIF(VALUE([At Risk]:[At Risk]), =1) - Returns Invalid Data Type Checkbox column formula:…
-
How to calculate using a 7 day workweek (to replace NETWORKDAY)?
I am using this formula to calculate the # of days it takes to get to a particular task called, Enable. Range 2 = %Complete and Range 1 = Start Date of Enable. It calculates correctly using 5 days per week. I am now being asked to count using 7 days per week. Is there a comparable function that I can swap out for…
-
Weekly Report
Hello Smartsheet folks, Does anyone know how I can create a report that only show data results every week? I have a data sheet/report that shows what store was complete, their unique information and the date their installation was complete, for the entire month. From this data sheet/report, I want a weekly report that only…