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 thei…
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 | Appr…
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 c…
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 sear…
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 wher…
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 …
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 …
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.…
