-
Has Children Function
Hi, I am trying to create a formula that will output the average of the child rows IF and ONLY if a line has child rows. If a line doesn't have child rows, I would like it to output (for example) the number "0" if the status column, Status@row, is "To Do" and "100" if Status@row is "Complete". Please let me know if there…
-
Countifs contains
Trying to count if a cell by criteria if another cell contains "device": =COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) #INVALID OPERATION
-
Need help with a couple Formulas for On hold and Certain Counts
First formula - In a sheet, in sheet summary I need a formula to count the instances certain Project Channels show up. There are three that will need to be counted. For now let's just call them Channel 1, Channel 2 and Channel 3. They are a dropdown column. Second formula - same thing-same sheet and sheet summary formula.…
-
CAPTCHA disabled on a Form, form users still being asked to CAPTCHA process
-
Formula Help
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…
-
=IF (multiple criterion) then mark as "Yes"
I am trying to make a cell read "Yes' or "No" based on criterion from another sheet. Basically, if all projects under a certain package have set schedules then the cell should read "Yes" and vice versa "No". The issue is that there are some parameters needed to determine if a project is under a certain package. A Project…
-
RGY Balls Question on formula to have them change upon reaching a date
I have a SS where I have contract dates. I've a column that is the 'Take Action Date' which is 300 days prior to the contract expiration date. When it hits the Take Action Date, I want the status ball to change to yellow. And when it reaches 120 days prior to the contract expiration date, I want the status ball to turn…
-
Help with Conditional Formatting for "Overall Health" Column
Hi everyone, I need help modifying my "Overall Health" column to account for more than two different colors in a row. Right now, my logic works as follows: If all values are green, the overall health is green. If there is at least one yellow and the rest are green, the overall health is yellow. If there is at least one…
-
Record A Date - Which date will it track if same action happened more than once?
When I create a Record A Date to track some of the options in a dropdown, and someone picks the same value twice (in between a diff value may be selected), which date will the system track, the first initial date when the option is selected, or the last? Thanks!
-
If formula to provide forecast categories
I'm trying to create a formula that will give help identify when future tasks will begin based on the Start date. The formula must provide whether the task is more than 30 days as "Inventory", less than 30 days from starting as "Forecast", or within 5 days of starting as "Upcoming". Below is the formula I came up with but…