-
Formula to Automate Dates
Hi! I am looking for a formula for my "Actual End" Column that will auto-fill the date when the "Assigned To" statues a task as "Complete. Can anyone help with this? Krista
-
Need assistance on #Invalid Operation result
I'm trying to create a formula in a parent row to return the most common value of its children (High, Medium, or Low) and keep getting an #Invalid Operation error If there are equal or more highs than mediums or lows, the parent status should be High. If there are equal or more mediums than highs or lows, the parent status…
-
Status update to Full depending on drop down list selection
Hi There, I'm attempting a formula based on the responses of certain calls that come in or calls we make. There are 4 columns total where we are either calling out to somebody and trying to track response, or they are calling back in and we complete the employee. When we call out, we have to call out every 2 days up to 3…
-
If statements
I am trying to generate a 1, 2, or 3 depending on if certain cells have text in them. So far I have =IF([Invoice Number]@row = " ", "1" , "2"), IF([Paid Date]@row = "<>", "3" ,"2") What I need is if invoice number is empty a 1. if invoice number is full and paid date is empty a 2. if invoice number is full and paid date is…
-
Rental Availability Formula
I am trying to make a formula in smartsheets where I can check availability. We have a current schedule that consists of events where a trailer is booked out between dates. I have formula that will give me the daily count of how many trailers are booked on a particular day. =11 - (COUNTIFS([Restroom Trailer]:[Restroom…
-
Is Automation Workflow can be triggered by Formula resulted change?
Hi there, I am trying to make a task automation with multiple steps. The idea is I have a master sheet where the task is being copied to from reference sheet (where all tasks in there). The Logic is, when the first task in the master sheet is completed, the second task row will be copied to the master sheet. I have a…
-
Unique calendar year- Countback week number to delivery
Hi All, I am struggling with a formula that I think needs a simple fix, and I am hopeful the community can help. Our product launches mid-week and runs off of a unique 35-week calendar, and we are using the following formulas to track the difference between: THe difference between current workweek to the week of launch:…
-
sum hours of an assigned to, in a multi contact column
=SUMIF([Assigned To]:[Assigned To], =[Assigned To]@row, [Hours Testing]:[Hours Testing]) Works great, if the "assigned to" is only a single person. When there is more than one contact in the cell, it is unable to find. I'd like to not have a name spelled out in the formula eg "Jane" I'd rather it look to =[Assigned…
-
INDEX MATCH MATCH to OTHER WORKSHEET
Hi, I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets. How do I reference the columns as a range and a value? The formula should be as follows: (in cell B2)…
-
Using COUNTIF and OR functions to match a value within a range of cells
I have a Status column with around 10 values (A-J). I would like to count the rows where status value = A, B, or C. I've been able to do this via an OR function in which I explicitly list the values sought after (e.g. =COUNTIF({Status}, OR(@cell = "A", @cell = "B", @cell = "C")). But this can get quite lengthy if I'm…