-
Max of Children Formula
Hi Formula Friends - I'm trying to calculate the "next test date" based whether a cell is "Surveillance (Monthly)" or "Baseline (Initial)" or "Response (Weekly)". In the formula, it must take into account the following: If Test Strategy in Parent Row = Surveillance (Monthly) or Baseline (Initial), then the Next Test Date…
-
Is the Today function actually being forced to update?
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Formula based on System-Generated Created Time
Is there are formula to bring the time out of the the System-Generated Created Time to e.g. add on 20 min to this and then perform an action? I have an easy sheet which is filled via 2 forms; one form is used to check in, one is for the check out, filling the same sheet. Problem statement: If someone forgot to check out,…
-
Cells with IF functions somehow linked
I have 2 columns on sheet A, each with a large IF statement. They both look to fields on sheet B (the same sheet but different fields). For some reason if on field updates, it updates the other field. They are not linked or copied in any way. I've manually rewritten each IF statement more than once. No matter what I change…
-
Why is it that when I drag a formula the information I am looking for is not preserved?
Esta es mi función: =COUNTIFS({LAYOUT CHECK FOR DAL Rango 2}, $Date$1, {LAYOUT CHECK FOR DAL Range 5}, "DAL 2", {LAYOUT CHECK FOR DAL Range 6}, "No") Si la arrastro en otros ´10 ítems hacia abajo, se pierde la secuencia lógica, lo subrayado en gris es la columna "Rango" que no respeta Cuando actualizo referencia hace como…
-
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…