-
IF formula for previous date
I see a lot of "countifs" solving this which is great except I need a straight IF formula.... I am trying and failing to come up with a formula that tells me if something occurred the month previous. For Example: IF [Occurrence Date] was previous month, "Previous Month", ""
-
Summarizing a Report by value count in a table
I created a report combining several different sheets, and I am trying to create (anywhere) a table that can count each topic from that combined report. Id like the table to keep updating as new topics are added. For example: Respiratory System | 1 Endocrine Systems | 1 Behavioral Health | 5 Thank you!!
-
Can I change the text in one column if the box is checked in another column?
For example: Id like to change 'Status' column to "Completed" if the 'Published' column box is checked?
-
COUNTIF CREATED SYSTEM COLUMN
can someone please assist with this? i am trying to count # of days in the created date system column for August 17th & August 18th my formula is not working
-
Tasks due within # of days
Sorry I know this is silly but can't figure out the formula looking at examples. I want a value returned if 'target end date' is due with 7, 15, 30. I have this working but can't seem to figure out how to add the additional criteria to include the other values. The values I want to return are just looking at Target End…
-
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…