I love using the Generate Formulas tool but have a suggestion. In addition to the "Apply to selected cell" option, it would be awesome to also have the ability to apply the output explanation to the column description.
Sign in to see the current vote count, add your own vote, or leave a comment.
Hi @mcullen
It seems you are having fun with this already.
@Genevieve P. sorry to be tagging you here but I have a question and not sure how to catch your attention.๐๐. My question is, can the "generate formulas" tool reference other sheets? I tried writing a couple of things I want to do in my own words but it always seems to generate the formula base on the sheet, even after I type out the sheet and column name I want to reference.
for example, "Referencing the xxx sheet and ccc column, write a formula to count [bbb] in the ccc column of xxx sheet"
Hi @Jacob A
Unfortunately, the Generate Formulas only supports referencing cell values in the current sheet. You can't reference values in other sheets.
Here's a link to a resource guide that I thought was really helpful:
If you scroll to the bottom, there isa "Know Limitations" section.
Hope this helps!
Oh seen, thanks for letting me know. I kinda figure, when I noticed that it kept generating formulas with the sheet. It was however helpful a bit though as it gave me another view of how to structure the formula.
I would read up on the resource.
Many thanks for sharing and have a restful weekend.
Jacob Alabi
Thanks for stepping in, @mcullen! ๐
We need the ability to duplicate (copy) an existing dynamic view to other sheets. We use templates and Smartsheet Control center, but when creating a new sheet (using SCC or Save As New) the dynamic view(s) are not also copied/duplicated. This creates a LOT of manual re-work. It'd be great if, from the Dynamic Viewโฆ
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial inโฆ
Please add the highlight changes feature to the new Tables view!
