Connect with peers, share your expertise, and inspire whatβs next in Smartsheet β from proven practices to practical how-to insights from fellow users and product experts.
Sign in to see the current vote count, add your own vote, or leave a comment.
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.
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! π
Sign in to comment or add your vote.
