-
How can I use two different inputs to determine a specific result in one cell?
Hi there - I'm not sure what is the best formula to use & appreciate any help! I have a 9 different scenarios that can return 4 different results. This is something like a matrix translated into the possible combinations. The matrix / combinations are in a separate sheet but can also be built into the formula directly, if…
-
Formula to count child rows that have not expired
Hi all, I have a sheet that contains parent and child rows. Each child row has an expiration date and I want to count the number of child rows that have not expired based on the expiration date in that row. Can you assist? Thanks!
-
Count and provide unique numbers
My need is to provide a unique and incremental number for each row, so when a new item is added it gives it the next number in that category. The current formula is =COUNTIFS(Created:Created, <Created@row, Type:Type, Type@row) + COUNTIFS(Created:Created, Created@row, Type:Type, Type@row) However, because it's based on the…
-
Start-to-Finish Predecessor Question
Hello, I am having some trouble with the Start-to-Finish predecessor. There is a repetitive section in my Smartsheet and I am trying to have one copy the other in terms of dates, so I thought the Start-to-Finish function would work perfectly but it doesn't and none of the others (FF, FS, SS) mirror the dates from which…
-
Sum number of items based by Product Category selected
Hello: I am creating a Purchase management based in the template loans. I just use one sheet _Small Business Request Intake Sheet it has these columns So in the sheet 📌 Purchases Metrics (Do Not Edit) I am creating a column called "Total units" based in the purchase category that show me the number of units are requested…
-
If Month = 12
I am trying to get a formula to count the number of instances that match certain criteria if it was created last month in the current year, however, I don't really know how to add in if last month = 12 then look for last year. In the formula below [Last Year]1 has a value of 2019 (formula to show whatever last year was)…
-
countifs use
Trying to get a count of items where the 1st criteria is Machine is 801 and 2nd criteria is Training level is 8. any help would be greatly appreciated! What I have in there now comes back unparseable.
-
Display Total Sum of each task status
Hello, other than creating a filter view, is there a way to display an active count of each status, for all tasks in a sheet? e.g. I have 20 tasks with a status of "Open", 15 tasks with a status of "In Progress", and 22 tasks with a status of "Resolved". Without filtering by each status type I'd like to see somewhere, the…
-
Looking to auto select a value from a drop down when previous field has any value
Basically I have a contact list and when any contact is input I need to default the next field "status" to be "open - assigned". So as soon as someone is assigned to that item it is no longer the default of new-unassinged and changes over to open-assigned. I have been trying all sorts of formulas with no luck. Help :)
-
Need help with formulas using health status and dates
Hi, I'm trying to do a formula in the "Health" column. Once we are within 30 days from the due date, the status turns "Yellow" and once it is within 7 days of the due date and past it, the status would be "Red". Any other status would be green. I'm at a lost to where even to begin even after viewing some of the videos. If…
