-
Formula Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
Merged: Viewing window for Formulas
This discussion has been merged.
-
Merged: Enable move of formula editor window
This discussion has been merged.
-
Index/Match Formula
Hello, I am needing advice on using this cross sheet formula to produce values in a cell. I have one sheet that is populated by responses to a form. I have another sheet with a list of people and their contact details. As the form responses come in to the sheet, I would like their answers to also populate on the other…
-
text to columns
Hello. I'm looking to split out the following string to provide just the supervisor name and I've yet to figure out the formula.. thoughts on how I do that in a helper column? Thanks Supervisor | Approved by Little, Paul on 12/4/23 @ 11:42 AM |
-
Dashboard
I have a metrics sheet that I send every Monday to leadership. However, I'm finding that I need to look at prior weekly metrics for comparison. Since my metrics sheet updates constantly, how would I capture that data without having to log it manually each week? I know this is a vague question. My formula knowledge is…
-
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…
-
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…
-
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?
