-
If formula help - assigning names
Hi! I'm trying to create an IF formula where if certain values appear in the Product or State1 columns, it lists the same of an employee for assignment. Above are the columns I'm working with. The formula will be in the Employee column. Basically, if Product = Vermont Red, I want to assign Slim Julian. If Product =…
-
Calculating % of Yeses in child rows from Yes/No Column
I am looking to get a percent of "yes" in a column named "Yes/No" in the parent row. Example, I have a parent row with 5 child rows - 4 of the child rows have "yes" one has "No" I am looking to show the % of "Yes" in this case the result should be 80% with Yes. Thanks
-
Countif on a date field seems to be rounding to the next date when it is after hours?
I am using the Created Date auto-generated column for tracking purposes on a project. I'm trying to see how many entries happened on each day. I'm using =COUNTIF([Date Submitted],date reference)... very simple formula. It is showing I had an entry on a date where there clearly are zero entries. The only thing I can think…
-
Button functions
Hi, I am hoping someone may be able to help. I am moving from an Excel tracker to SmartSheets. On Excel, I have a button function which, when clicked, automatically generates a new entry at the bottom of the sheet with a unique ID number. Please see attached photo for reference. Is it possible to do a similar button…
-
Tallying Totals in Summary
=COUNTIF(Created:Created, YEAR(@cell) = 2023) Generates invalid data type Created is a autogenerated date time column when the row is created. example of format - I can get a single cell from the column to return 2023 using the Year() function but when using it in the formula above with @cell it errors. I feel like I am…
-
Check if a cell has data or null and move data from populated cell to another column
Hi all, I have 15 columns on a sheet that will only have one of them populated with data on the row. I want to add a column that will check the row for the data and copy it to another column in the same sheet. This should create a column that its full from top to bottom with the details from the row it's on. My head is…
-
AverageIF formula
Hi all, I probably have a stupid question. But in the attached example, I would like to calculate the average from 'chance to win' column if 'Football teams = KRCG'. In addition, I would also like to calculate the average from 'chance to win' column if 'Football teams = RSCA' and 'Yes or No = Yes'?
-
Formula for filtering multiple columns to get an expense total
NEVERMIND ;-) Sometimes you figure it out 5 minutes after asking! lol =SUMIFS(EXPENSE8:EXPENSE1915, [VENDOR PERSON]8:[VENDOR PERSON]1915, NOTES@row, ID8:ID1915, OR(@cell = "CAPACITY")) Hello, I have a formula I need to expand on to add another column of data to filter what I need. Using this formula now to get an overall…
-
Solution for extreme amount of conditional formattting
Hello!!! I have a scenario that has an extreme amount of conditional formatting requirements. if completed, the sheet will have over 10,000 conditional formatting rules. While hear there are not limits to the amount of rules, at 1,800 the conditional formatting dialogue box really doesn't want to open any more. Has anyone…
-
Conditional Formatting if Time is later than 5:00PM
I am using the TIME function in my Planned Start Time and Planned End Time. Planned End Time is calculated using the Minutes Duration column (=TIME([Planned Start Time]@row) + [Minutes Duration]@row). I want to set up conditional formatting to highlight times that are outside of business hours. I tried to set conditional…