-
Formula to look as Multi cells to check a Box on Another Sheet.
looking for help. not even sure how to Word this. but i am looking for help on writing a formula that would check a box on another sheet if this form is filled out and a assigned work order #. so if someone was to say that Step 1 is Complete with this work order #. it would Check the Step 1 box that is in the tracker…
-
LEN ... FIND ...
Hi there! I know there is a way to do this but I keep getting an error! I have these long zoom links and want to just pull the ID number into a column. I was trying the LEN and FIND functions but not having any luck. The number is always between https://zoom.us/s/ and ?zak= The random string of characters after ?zak= is…
-
Count(Distinct(Collect Formula
I am trying to write a formula to return a count of the number of unique IDs market propject and then counted by market. From what I have been reading it seems like a count(distinct(collect formula is needed. Also, I might need a helper column on my source sheet to determine which rows are unique.
-
Troubleshooting COUNTIFS with Multiple Criteria
Hi there, I'm looking for some help with a formula. I'm trying to count the number of items labeled as "THD Resource" that are also marked as "Requested." Here’s the formula I’m using: =COUNTIFS({TBD RMT Range 3}, "THD Resource", {TBD Range 1}, "Requested") But I’m getting an #INVALID REF error. Am I missing something,…
-
How to get the count of unique values from a list of repeated unique values
I have a list of people lets say Jon Sam Rick each on of them is assigned to a colour lets say any combination of colours for something that looks something like this ( see screenshot). How can I count the number individual colours for each person. For example Jon has a combination of 5 red and 5 green so his count should…
-
using NOT
Hello, I am trying to write a formula to identify open deviations that are in another sheet. The column that I am referencing {Deviation Tracker Range 3} has multiple options for the stage it is in but I only want to collect what is in {Deviation Tracker Range 1} if the cell does not contain "Closed". (for reference…
-
Formula help to calculate sum of items across smartsheets
Hi Smartsheets community, I've recently created a Smartsheet with all the different types of meetings and then I have separate columns for the count of meetings attended, missed and chaired. In a separate worksheet, I wanted to create a summary (not using summary report) but it's only counting the number of rows created…
-
Countifs using multiple columns + if date is in the last 7 days
Hi all, I have two different formulas that I want to combine. They work separately, but not combined. Formula one =COUNTIFS([Roof AHU 1&2 Base Build Supply Fan]:[Roof Lights], "Yellow") Formula two =COUNTIF([Date of Plant Check]:[Date of Plant Check], >TODAY(-7)) I want my formula to pick up where the symbol is yellow but…
-
Can anybody explain this seemingly impossible formula result
We have this formula in the [Task Status] column of every one of our 82 production sheets (as a column formula). See the attached .txt file for a pretty printed version of the formula. =IF([DTM?]@row, IF( OR( ISBLANK([Start Date]@row), ISBLANK([End Date]@row), NOT(ISDATE([Start Date]@row)), NOT(ISDATE([End Date]@row)),…
-
How to create a time stamped column with the date
How do I create a time stamp column to auto populate the date and time of when a cell changed from blank to a value? The workflow to fill in a date does not provide the time and I cannot figure out a formula that would capture both date and time?