-
Formula percentage with additional formula for roll up percentages
I am trying to calculate a rolled up percentage of how many students have taken a test, scoring above 80% to those who have not taken the test at all. I have tried an AVG formula as a test for 5 takers, but the % is incorrect. Here is the formula I have used: =AVG([TEST 1: Establish Point to Point Connection]3:[TEST 1:…
-
How to add a Red Flag when there is an entry more than once in last 12 months
Hi, I have a table which records driving infringements. What I want to be able to do is have a function determine if a driver has had more than one infringement in the last 12 months. Then use the Actions and Alerts to notify their manager. But need the function to work first before I can do that. I know how to use the…
-
Raise flag if due date is within 30 days
Hi There I'm very new to smartsheet so for you this might be a very simple thing. I'll appreciate if someone let me know what'd be the formula if I want to raise a flag whenever the due date is 30 days from the current date. We'll appreciate your help. Thanks Raashid K
-
vlookup help
OK....so I am struggling with this vlookup. Perhaps I can not do what I want to do. Any comments would be helpful. I have a sheet that has customer number and customer name. Customer number is auto generated and is sequential. CU1000033 is my number. Name XYZ Sports Academy. I have a pitcher that uses XYZ Sports Academy to…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Sorting Numbers with a "-" in it
Hi all, Probably my incompetence here but i have a confusing issue at the minute. I have a long list of job numbers and am trying to sort them in numerical order. There is a criteria that we use to create these that you should probably be aware of: * Primary number is a 5 digit numerical number (i.e.21495) * If there is…
-
Aging Date Average
Hi Community, I am attempting to create a KPI for a dashboard that will capture the average number of days a 'something' has been opened, but only if it is still in an opened state. I can perform the appropriate "days open" with "=IF([Closed Count]3 = 1, NETWORKDAYS([Submitted Date]3, [End Date]3), NETWORKDAYS([Submitted…
-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…
-
Countif children row with reference another sheet
I want to count the children rows in another sheet that contain a certain value, my attempt gets an #UNPARSEABLE =COUNTIF(CHILDREN(){Lease Tracker 2018 Manager},="CORNELIUS")) Any thoughts? THANKS!
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
