-
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
https://us.v-cdn.net/6031209/uploads/R00HCP77EPPO/formula.txt 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),…
-
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?
-
Missing formula function. Please help determine!
Good morning Smartsheet Community. Hope you all are well. I'm looking for help to find the proper function to help me achieve what I'm trying to do. I have three columns seen in the screen shot below, Rough In Date, Install Date and Tech Date. I currently have the following formula in the Tech Date Column.…