-
With COUNTM I can determine multiple selections are made, how can I extract the specifc selections?
If I have a multiple selection column, like 'assigned to', where I can select some or all of the people, can I determine which specific people from the list have been selected (without using FIND or CONTAINS and looking for names one at time?
-
How do I write a formula that only finds unique or duplicate text from a single column?
I have a sheet with 7,195 rows of data. I'm trying to write a formula that looks in the "Full Name" column to find which names are unique and which are duplicates. Any suggestions? I've tried this formula: =IF(Countif([Full Name]1:[Full Name]7195, 1) I also thought using the DISTINCT function may help, but I'm not sure.
-
Auto Checkbox
I would like a formula to check a box for open cases. I have a start date column and an end date column. Only check the box when there is a start date and no end date entered. Thank you!
-
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…