Improving Formula Descriptions

I feel like it could be better shown, for a variety of examples, how formulas can be used. For example, this image doesn't really tell you what the answer to the example is. The example only shows that those data types can be used but doesn't help you understand what it does. Minor gripe I suppose. Also sometimes I wonder if I can use an array input or only a single value into some formulas (because in Excel this is commonly possible), but it seems "matrix" math type formulas aren't really supported here. Nevertheless, I feel like being more detailed about data types, showing the results of the example, and possibly giving some examples of advanced use-cases would be a great improvement.

Thoughts?

Find more posts tagged with

Formulas

Enhancement Request

Comments

Genevieve P.

Hi @Preston Murphy

Thanks for sharing your feedback! The Product Team is responsible for updates like these, so it would be great if you could provide this same information to them in this form, here.

That said, it looks like you're reviewing the formula help window when working within a sheet. From that window you can click on the "Learn More" section at the bottom which will take you to the Help Center page for this function (see here: RIGHT). The Help Center has more space to go into detail and provide examples and use-cases of each of our functions.

You can also find a sheet filled with formula examples in the Solution Center (search "formulas" and it will pop up: Smartsheet Formula Examples). I personally find this the best resource as I can see the function working in a sheet, instead of just reading about it. I hope that helps!

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.