-
A column using the ANCESTORS, is it possible to get it to display "Top Level" of a hierarchy?
I was wondering if it possible for this to work? I want the Parent Details to read "Top Level" if the Task Name is at the top level of the hierarchy. This is the formula I have come up with: =IF(ISBLANK([Parent Details]@row), "TOP LEVEL", JOIN(ANCESTORS([Task Name]@row), " > ")) This is reading back circular reference…
-
Need help with a formula
I am trying to calculate a percentage of items that meet a specified criteria during a particular period. I can calculate the percentage correctly [=COUNTIF(A:A>3)/COUNT(B:B)] but can't figure out how to add the filter for the period (it's a "Month" column). =IF(Month:Month=7(COUNTIF(A:A,">3")/(COUNT(B:B),"") does not work…
-
How can I sum one column based on dates of another column?
Hello, I am trying to sum up the revenue generated during a fiscal year. I have one column titled "Payments Received" and another column titled "Date Received" and would like to tally the totals received for each fiscal year (July 1 thru June 30). I've attached a screenshot of the columns. I have been trying to build a…
-
I'm getting both an Approval and Denial notification at the same time
I'm getting both an Approval and Denial notification at the same time. If the request is denied, I get both an approval and a denial notificaiton. Same if the request is approved. My status column is set up with a dropdown, because I don't want more than one column for status. However, from what I am reading. It sounds…
-
Only copy certain columns to a new sheet?
I am trying to marry two sheets together, one is a new sheet for ticket intake and the other sheet has been in use by another team that has ticket information for one person but also additional information for their team. I don't want the team to have to enter in the data into the intake form in addition to their form. I…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…
-
Using the "parent" function for a formula
How do I write a formula to total up a percentage using the parent row? I want to count the # of 100% complete, in the % complete column, if the parent row is equal to a location name (ATL 1) I would be referencing another sheet to do this. I think the #no match arguments might be causing this not to work?
-
Delimit Date/time in a match/index function
Hi all, I'm using a match/index function currently to pull over data from another sheet. Currently I'm using this: =IFERROR(INDEX({Google Sheets PTI Daily Form 6/19/23 Range 7}, MATCH(claimNum@row, {claim num}, 0)), "") The sheet I'm referencing in the function has time and date in the same column, so the above formula…
-
If statement using two dates
This has got to be simpler than I am making it. Column1 is a manufacturer date Column 2 is a Replacement date (calculated by adding 1825 days to column 1) Column 3 needs to be Fiscal year. So If Column 2 is greater than or equal to 10/1/2025 and less than or equal to 9/30/2026 then FY26 Help here?
-
Count function
Hi I need help with a formula. I have a column that I want to count but only based on a values in a different column. I have tried the following formula but it's not working and I can't figure out what I am doing wrong. =countif([Test Script #]:[Test Script #], [Pass ?]:[Pass ?], <> "N/A") The Test Script # column is the…