-
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
-
Updating cells to Formulas
I have a sheet that we track miles for vehicles for services so 1 column is for a A the next B service. those columns set of formatting against currant mileage and let the mechanic know if a service is due. the issue we have is the A is every 18K miles the B is 36K miles. When a B service gets done it resets the A service…
-
How to do lookup for multi select dropdown cell to return results for all selected items in cell?
Hi I'm trying to do a lookup or index/match or whatever that can search all values in a dropdown list cell with multiple values and return multiple values. Sheet 1 screenshot (yellow highlight is where I want formula to be): Sheet 2 screenshot (contains table of lookup values): I'm trying formula from this question from…
-
FIX Required: Last Modified Date + TODAY Function = updates all rows
Hello Smartsheet community I would like to see a fix. When you use the "TODAY" function anywhere in your sheet, ANY changes will update the "last modified date" for all rows. What I want: Only update the individual row that has changed. Why? So I know when (and who) made the last change. This was verified as a problem by…
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
Calculating Averages with Different Columns
Hi - I am trying to calculate average based on different columns, example… Sandra A - TTL Seconds + Kelly B - TTL Seconds + Meri - TTL Seconds + Coen - TTL Seconds = Average of those numbers for each row Does anyone know the formula to do that?
-
If statements with currency positive and negative and needing value
I'm having to try to create several formulas so that I can in turn create triggers. I need to say if there is a value in cell A with a difference of $1 (positive or negative) from cell A and cell B I want it to say notify, if not say no. Anyone have a suggestion. I had =IF([Cash Distribution (AM)]@row - [Received Cash…
-
Allow viewing of Formulas on View only or Locked Shared Sheets
It would be great to be able to right click on a cell and "copy formula" or "Show formula" so that it could be copied, for viewable sheets. Or, create a sharing method that allows viewing of formulas. This is mainly for sheets that community users share as solutions to questions. It would allow us to actually see the…
-
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
-
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…
