-
Is it possible to get the reference of the First Parent ?
I would like to extract the sub-parts whose biggest Parent is called Media communications. Is there any function that allow us to extract the name of the biggest parent instead of the closer one ? =Parent(Example@row)
-
Count if checkbox is checked in each week of the year.
Hi I'd like to count a row if a checkbox is checked within a specific time frame. e.g. If Column 'Role' is "LMS" and column 'Complete' during a specific time period (e.g. week 6 of the year), count as 1. =COUNTIF(Complete:Complete, Role:Role, "LMS", Complete:Complete, "1", WeekNumber=6) I've been playing with various…
-
Combining an IF / MIN Formula
I am using a COUNT IF / MIN formula to pull in the next upcoming date based on a specific name within a range, but the formula I have is not working. Here is the situation: Sheet 1: A sheet for an individual client's open cases. Sheet 2: A sheet that includes milestone dates for ALL clients. I would like the ability to…
-
How to Send Timed Reminders Based on a Trigger?
Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declination. I'd like to send reminders if no one answers that approval, though. What I'd like to…
-
Index Match formula returning #NOMATCH, can search type be a formula?
I am attempting to create an Index(Match( formula to pull job names based on a job number, but I am getting a #NO MATCH error. I have used this formula hundreds of times, so I am wondering if this is because my Match search type pulls from a cell that is also a formula?? Any workarounds? This is my sheet, I want to use the…
-
What can I add to return a blank if the cell referencing is blank?
I have a formula that pulls in some information from another sheet. =INDEX({Function}, MATCH([Support Manager (email)]@row, {Assigned}, 0)). The formula works fine except that I want it to return a blank if the "Support Manager (email)" is blank. Unfortunately the "Assigned" columns in the sheet it is referencing has…
-
Automatically Add recent changes information to a row.
Hello, I'm trying to look If there is an option to automatically update the changes happened in the worksheet from past 10 days in to new column (Lets assume the column name is "History_Past10Days") Information I'm looking in this column(History_Past10Days): All the column Names updated from past 10 days Ex: Sheet has 20…
-
Formula
Hello, I am trying to find a formula that will allow me to have a count of running occurrences. For example, on the first occurrence of “A”, a 1 will show, then 2 for the second; 3 for the third occurrence, and so on. I know in Excel I can use COUNTIF, but when I try it in Smartsheet it returns the total number of…
-
Counting all children, including nested children
Hi - I think I have stared at this enough and tried many ways of sum and count formulas, but is there an easier way to count ALL the children of the highest outdented parent row which has multiple "sub-rows" with children underneath? I am trying to count the cells that are nexted beneath those rows and the children ()…
-
Any formula that can help me to calculate the number of the employee
Hi all, I am currently stumped by which formula to use in order for me to calculate the number of the employee. As you can see from the screenshot below, I was planned to calculate the movement of the employee in monthly basis. So, currently the formula that I using is: =COUNT([Joined Date]@row) - COUNTIFS([Last Working…