-
Formula Help w/AND
Hello Community! I really struggle with formula syntax. Here is what I'm trying to do. I have a project plan and when certain milestones complete, I want to count the actual "widgets" I completed. My project plan has multiple phases so the completion of each phase adds more widgets to the bucket and I want to reflect that…
-
Formulas for auto creating start time / end time based on duration - Event Runsheet
Hi, I am wanting to create an event runsheet. I have a formula that automatically calculates the duration from start time / End Time but Im having trouble figuring out how to automatically calculate Start Time / End Time from Duration which is more Ideal. I could enter a Start Time & End Time in the parent row and then in…
-
Looking for help with countif formula
I'm having some trouble with a countif formula, looking for some assistance. My goal here is to count the number of time the Created Date is last month and that the service type is "Trade Database - Add Part Number(s)" When I enter the formula below it works great! =IF(MONTH(TODAY()) = 1, COUNTIFS({Genie Archive Created…
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Formula to pull data from one sheet into a different sheet.
Hello Smartsheets, I am building a sheet that will track an employees attendance of our monthly trainings. Sheet #1 is the raw data, Sheet #2 contains all of the formulas and combines all raw data in a legible way. See photos below. Sheet #1 This sheet contains all raw data received from the attendees of each monthly…
-
How to count number of vendors in each country?
Hey Community, I am simply trying to calculate the quantity of contracts assigned to each vendor per country (Ex: I want to see that IBM is covering 100 contracts for us in the United Kingdom). The columns I have to use for this are the following: Vendor assigned, Covered Country (on the same sheet) Countries, Vendors (on…
-
Achieving Optimal Index-Match Performance
I'm wondering if anyone has any insight as to whether or not Index-match works any faster when the fields being used in the look-up contain numbers only, instead of text or text/number mix? In my own anecdotal experience, sheets that use index-match on numbers-only columns do seem to open/update/save faster. But I have no…
-
RYGB Lights Not Changing with Dates
I am not sure why my lights wont change based on the dates: =IF([Original Due Date]@row < TODAY(14), "Yellow", IF([Original Due Date]@row < TODAY(7), "Blue", IF([Revised Due Date]@row > [Original Due Date]@row, "Red"))) Would like: Yellow: <14 days from today Blue: <7 days from today Red: Revised Date < Original Date
-
Formula Assistance (COUNTM??)
Hello all, My team and I are hoping to build a formula to do the following: First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color." So, for example, the answer for this would be 4 (because there are 4 items in the "Color" column that belong to Group A).…
-
Countif with column and cell reference instead using "XXX" name
Hi, i am building a large list of client that i going to use to create Dashboard with counting items per each client. My question is (maybe it is very basic), is there a way that in the formula Countif i can refer to the cell and column instead or using the "XXXX" name in the formula? here the formula that i am using and…