-
I need a formula to find the average of the Count of Training IDs
I have a grid that intakes via a form, training evaluation answers. Each row of responses has a TrianingID associated to a specific training. I have been ask to find the medium average if the number of responses received per trainingID It needs to be a column formula due the new TrianingIDs populating as more and more…
-
adding and subtracting from inventory sheet based on orders
Hello, what im trying to accomplice is when selecting a item in the drop down menu "equipment shipped" for example "logitech". i would like it to subtract a quantity of 1. example, we have 200 and in our inventory sheet. i would like it to look at our inventory sheet and subtract 1. i would also like to do this with if we…
-
Comma Separated Text/Number to Multi-Select Dropdown
Hello, I am looking for a formula or a formatting solution to move comma-space separated, text/number, field values to a multi-select dropdown field this way when I am filtering my final report, I can use a "has any of" filter instead of having to use separate "contains" filters to find the information I need. See below…
-
SUMIFS Formula Help
I want a cell to count the total hours for different kinds of employees. The columns I have are: Job #, Date, Employee name, Employee type, employee hours I want to add up the total hours for each employee type, on the same sheet or another sheet, I just need help to add them up by type.
-
Embedded Images from Excel to smartsheet
we have embedded images in a cell (excel) that we would like to import to smartsheet. We get the text, but where the image is it just says "picture".
-
Need help creating a formula that will remove a certain string of text.
My use case is: I need to remove everything within the parentheses and including the parentheses. Is this possible? I just need the name. I feel like the Replace, substitute or mid formula would put me in the right area but not able to figure it out. Ex: John Doe (123456789)
-
Formula SumiF
Hello. When I use the sumif between different Smartsheet and de column is formula the result not calculated but when put the value the formula sumif is ok. like attached. WHAT IS THE BEST FORMULA ABOUT THIS CASE? SumIf between two Smartsheet's, but both columns to search use formulas don't use absolute value between…
-
Unable to use formula based date column in gantt/timeline
Any workarounds welcome. I'm importing some task data using Data Shuttle. The task data includes Created Date, Start Date, End Date. We want to use a column formula to set the start date (if its empty) to equal the Created Date. Easy enough.. I renamed the incoming Start Date column and added a new Start Date date column,…
-
COUNTIFS multiple references to another sheet
This formula gives me an error #INCORRECT ARGUMENT =COUNTIFS({Total Lot Status Global-AgingInventoryDays}, <>"", {Total Lot Status Global-New Division}, "West", {Total Lot Status Global-SalesStatus}, "Spec") If I isolate each range and criterion under a simple, COUNTIF formula, then all three criterions work fine. It's…
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
