-
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…
-
TEXT to DATE Formula
Currently we are using an API to upload a "date" into our sheet, but can only upload it into a text column without causing errors with the API. To transform it into a date column, I have created another column that uses a formula to covert the text uploaded into a date format. However, I'm having troubles simplifying the…
-
COUNTIFS/CONTAINS - When more than one name is in a cell on the reference sheet
=COUNTIFS({Linear Master Tracker - Series - Current Status}, NOT(OR(@cell = "Lost", @cell = "Passed", @cell = "Term Deal Completed/Expired", @cell = "Premiered")), {Linear Master Tracker - Series - Legal Exec}, CONTAINS($[Primary Column]@row, @cell)) In the below function, I am trying to get CONTAINS to work successfully.…
