-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
COUNTIFS
I know this should be easy but I just can't get it right. Trying to count instances of 2 different values in the same column. There are 6 options within the dropdown in the column but I only want to capture the amount of 2 specific values, "Seller Rep" and "Fee" Tried every variation I can imagine of this:…
-
Using Index/Match with Two Values in Another Sheet
In Sheet 1, I like the prices for services for different vendors: Vendor 1 | Category 1 Service | $10 Vendor 1 | Category 2 Service | $20 Vendor 1 | Category 3 Service | $50 Vendor 2 | Category 1 Service | $70 Vendor 2 | Category 2 Service | $90 Vendor 3 | Category 1 Service | $30 Vendor 3 | Category 2 Service | $60 In…
-
Date Range Formula Help
Can someone please help me to create a formula that returns the number of items with a "Permit Expiration Date" between 7/1/20 and 7/31/20 AND has the "360 Photos Have Been Submitted" unchecked? I've tried several "if and" formulas and they didn't work :( Thank you!!
-
Date to move ahead 1 year from scheduled due date, unless RYG ball is "Not' Green
Hi, I am hoping someone could help me figure out how to create a formula to calculate the date, 1 year from a date selected if my RYG ball is "Green". This date would consistently be rolling toward the future unless an RYG ball is "Yellow" or "Red". I am working on a maintenance sheet, which we will be getting every piece…
-
Finding date in other sheet and adding into current sheet
Hi Guys I have a sheet with columns of information. One column has a "container number" which looks something like this "TCNU6307839" A few rows down i need to enter a date for this "container number". This date is entered in another sheet with the same container number in a row. Now I'm manually copying the container…
-
Creating Due Dates (Monthly & Quarterly)
Greetings I have been asked by a colleague to build a smartsheet that sets out a list of tasks to be completed and the due date of each task (to be used primarily in calendar view by the colleague to plan her time). Her due date for a task is either made with reference to: (i) a business day in a particular month (i.e.…
-
Index Match Formula with Multiple Criteria?
Hello, I'm trying to create an index that has multiple criteria. I'm not sure if I should do this using an "IF" formula, or if I need to incorporate the "AND" function into the formula. Or if I need to go in another direction to accomplish this. What I need to do is return the "Rate" based on the "Crew Type", and the…
-
Extract date and Time
Hello, Is it possible to extract a date/ time from an imported excel file? It is currently reported as a string 2020112717161730. Thanks in advance for the assist!
-
Total Count if value matching from multiselect cell
Please help, i have 2 sheets. One sheet (Second picture) contains week no. i.e. the week No (depending on a date) in which a member took leave or was absent. The other sheet (First picture): I wanted to count total week numbers from that column only if week number is mentioned in multi select cell (under Week Number…