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! 🙂
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
Hi, Please can we have Hex colors for cell backgrounds? The sheets I am making need to be branded with our own colours.
