-
Filter rows under parent row?
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue is submitted via the form for a High Priority. Have it automatically sort under the High Priority Parent Row? As of right…
-
#NO MATCH in a index match formula for some values
I have a "filter" table in which I can choose via dropdown "year" and "month" values. By updating the values there, I can update the values in other small table I plan to select individual values considering two labels, "On Time" and "Delayed". When I use the following formula, I get a #NO MATCH for certain months, but all…
-
Is there a formula which can number row hierarchies?
I am looking for a number which can categroise row hierarchies into numbers. I have a column called "Hierarchy" and in each row I want it to generate a number depending on what hierarchy the row falls under. For example, the Parent row would return 1, the child of that row would be 2, the grandchild would be 3 etc etc…
-
IF, OR and AND? Formula issue
Hi, I'm trying to calculate if we're meeting the schedule start date. The issue I have is if the Schedule Start Date is greater than today's date then it still thinks its completed on time. I think I'm missing AND statement with the formula? =IF(OR([Actual Start Date]@row = "", [Schedule Start Date]@row < [Actual Start…
-
INDEX/MATCH vs. VLOOKUP between two sheets
I have two sheets with identical columns - Market Name and Organization Name. I'm using dropdowns in these columns since I have external folks reporting into a form and I want the names to match across my entire workspace. I want to copy Organization Name from one sheet to the other, and match on the Market Name. I feel…
-
Link an entire column from 1 sheet to another
I know you can do this at the cell level, but is it possible to link an entire column? I'm trying to save the time of linking over 6000 cells and want the ability to grow as I know the numbers will be increasing over time.
-
Formula stops working when changing name of column
Greetings- I have the following formula that tells me what day of week a specific date is if the date column is called "Date". If I try and change the formula to reference a column called "Date of Program" the formula doesnt work anymore. Why is this? How can I make it work with a date column called Date of Program instead…
-
Total Age tracker overwrites last modified
Hi all, Hoping someone out there can help and hoping its just something simple i need to change. We use Smart sheets to monitor cases by age outstanding to help prioritise what needs looking at first. so i have a formula to grab data from a cell says A1 that has the TODAY function in. and then take that away from the last…
-
If Index collect formula to capture the Meeting slot availability
Hi All, I'm attempting to compare data from one sheet, which contains meeting bookings, with another sheet that lists all available meeting slots. My formula seems to work correctly when the condition is met ("True"), but it results in an "#INVALID VALUE" error when the condition is not met ("False"). Can someone assist me…
-
Accessing data in column summary at bottom of sheet
I have a sheet with a Time column tracking hours. I want to filter the rows and then SUM the value of this column (which right now does not sum just the filtered rows). I noticed the SUM of the actual filtered rows displays in a summary pop up at the bottom of the sheet when I select the column. How do I access the data in…
