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! 🙂
The "browse" button was recently changed to go through a recent workspaces menu and requiring a second click on "browse all" before actually bringing up the browse menu sidebar. This change is unintuitive as there is a "recents" button right below the browse button and for anyone who regularly uses more than 6 workspaces…
I need to be able to backup all workspaces at once. Backing up each workspace one by one is tedious and a waste of time. I know someone is going to tell me "even system admins cannot backup workspaces they are not shared to, and can only backup workspaces they own or are shared with." So, let me do that. At least let me…
Smartsheet does not currently send automated error notifications to Pivot workflow owners when workflows fail, unlike the notification behavior for DataTables, Data Shuttle, and Meshes. Also, when column mappings break on a mesh, the mesh will continue to run with an error. We should expect the same functionality from a…
