-
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…
-
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.