-
Formula for dividing 2 columns then multiply by 12
I am trying to get the average for a specific category (Column 1), by dividing YTD Terms (Column 2) by YTD Headcount (Column 3) then multiply by 12 for my Column 1? Here is the formula I am trying and I get Unparseable. =COUNTIFS({Turnover ratio by Dept July 2020_YTD Term}, /{Turnover ratio by Dept July 2020_Average…
-
What is the formula to find a criterio (Yes or Not) in a report on specific date wit rule (Today)?
I used the formula =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "Sí") to found discrepancy for all days but I want to lear how to find in a specific day "Today ever" Please help me.
-
How to use Countif when the cell is hyperlink to a url
I need to do a count of cell value which is a hyperlink to a url (the cell display a number that refers to the url) e.g. 285555 which links to (http://blahblahbla.com/285555). How do I use COUNTIF for this type of data in the cell? Thanks, Aye
-
Are you able to associate answers with number values?
I am attempting to create a form similar to the one attached below: Is there a way to associate the answers a user inputs on the form to a number value and then add them up to a total? Thank you for the help in advance!
-
Counting Grandchildren Rows based on multiple criteria
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have children too (quarters). For each quarter, I need to count the number of grandchildren in that quarter that have a date in my "Date…
-
Can I extract the name of a column and use it in a formula?
I have a table set up with data organized by quarter (3W20, 4Q20, 1Q21, etc), and am using the quarters as the names of the columns. I have formulas in the columns that display data for that quarter, but I've had to manually type in things like "3Q20" in my SUMIFS formula for one of the criteria. Is there a way to pull out…
-
¿Cómo encuentro el valor de auditoria diario?
Esta es mi formula: =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, "14/08/20") Cuenta si en columna 5 encuentra "DAL 1" Cuenta si en columna 6 encuentra "Si" Pero como hago para que busque siempre en fecha actual, es decir con alguna función today
-
'Request an update' Automation: 'Condition' where column contains a cross-sheet reference.
Will the automation “Request an update” fail if the 'Condition' column contains a cross-sheet formula that pulls data from another sheet? For example, there are two Smartsheets: Sheet ONE contains Project ID, MFG Rep and Customer Price. This is the source sheet for Project ID and MFG Rep. Sheet TWO contains Project ID, MFG…
-
Is there a way to use a CountIF formula that would ignore hidden rows/cells?
Hello, I am am trying to create a summary report that would count the number of "complete", "not started", and "In Progress" with only using the rows/cells that are filtered. I do not need to count the rows/cells that are hidden but when I use the COUNTIF function, it would also count the hidden rows/cells. Thank you.
-
Sheet Summary Formula Needed: Sum all numbers in a column for rows which match a criteria
Hi, I am looking for help writing a sheet summary formula that will sum all numbers in Column B for all rows matching a criteria in Column A. I have a sheet that tracks transactions by salesperson. Each row is a transaction. I have column that contains the commission for the salesperson for each transaction. In the sheet…