-
Is it Possible to Use INDEX-COLLECT When a Criteria Field is a Multi-Select Dropdown?
Hi, all; I'm hoping you can help me with this one. Here's my boggle: Sheet A collects Milestone and Parts data from a form and datestamps each entry. Sheet B has columns (Milestones) and rows (Parts) corresponding to the data entered in Sheet A, and the cells pull the date for each entry from Sheet A. For simplicity, we'll…
-
Is there a tool that would help me take snapshots of progress every 30 days?
I am trying to figure out how to make a progress report that would show the percent completion of our project 30 days before and 60 days before. Is there any tool that would help me take periodic snapshots or be able to pull all the data onto a sheet every 30 days?
-
Hidden Sheet Values - =Index(Match) - Help Please!
Hi, I'm reaching out to get some help on an issue I've been trying to solve for a couple days now. I have 2 sheets of data. The first named "General 6S Form Sheet v.02", where the data comes from a form and the second named "6S Audit Schedule v.02", where the data comes from "General 6S Form Sheet v.02." The intent is to…
-
What is the correct COUNTIFS/TODAY formula for past and future 90 days?
I am trying to COUNT the tasks assigned to departments in the past/future 90 days. I am using sheet summary fields for this data. These are the formulas I have come up with but they are not accurate. =COUNTIFS(Department1:Department72, "fsb", [Start Date]1:[Start Date]72, <=TODAY(-90)) =COUNTIFS(Department1:Department72,…
-
Mileage reimbursement Help
I have automated an expense report. This worked great as I did an index/match on the date the expense was for, compared to the year, and reported back the mileage reimbursement rate. =IF(ISBLANK(Miles@row), Miles@row * 0, Miles@row * (INDEX({Mileage Reimbursement master Range 1}, MATCH([F*Year]@row, {Mileage Reimbursement…
-
Returning a Value When an Item is a Child of a Parent That Has a Specific Name
I need to create a formula that looks at all children (of varying levels) within a parent, and returns a specified name in a column for ALL children rows when the level 1 parent value is X.
-
Multiple Sheet Check and Data Return
Each month I have to put together a collection of data to compare from different sources. Two of the sources have older material and I am trying to find a way to not duplicate items I have already checked. Can someone help me put together a formula that is something like the following. Check box if Name (Sheet 1) equals…
-
Formula help please
Hi I am trying the formula below and it is returning a #NO MATCH (see image below for the Factory QC Signoff Ass n Fin reference sheet) =VLOOKUP([Clean Job Number]@row, {Factory QC Signoff Ass n Fin}, 5, false) Perhaps the issue is that the "Clean Job Number" column has a formula to extra just the 5 digits of our job…
-
Concatenate - Display field in different Date format
All, I need a field that provides the following output in the sheet below: 1 (2-Jan-2023). I do have all the components and basically I need to concatenate Nr. & the Start Date.. but Smartsheet keeps on changing this to the default format, despite my column format. Sprint number is currently : =[Nr.]@row + " (" +…
-
Hello! I need help with a formula, experience with Countifs OR AND formula?
I am not sure if I am doing this right, I need to count "reference another sheet" if status is closed, completed OR sent to contractor (any of them), AND program is "APD". Here is my formula: =COUNTIFS(OR({Classification Review Status}, "Completed", {Classification Review Status} = "Closed", {Classification Review Status}…
