Best Of

This is similar to what I am looking for as well. I would like to share reports without sharing the parent sheet. I have a central budget sheet that multiple offices submit to, however I would prefer the offices not be privy to every other offices' submissions. Unfortunately I have not found a work around as data gets updated so individual sheets for the offices that combine into a roll up sheet would not work effectively.

Two years later - is there a solution for this?

Hi there. I'd like to submit an enhancement request for Smartsheet integration with non-production Docusign accounts (Demo and/or personal sandbox). This would support standard life cycle of development and production deployments; it would also eliminate cost associated with sending test Docusign envelopes in production. Thank you. Radke Novotny

I would like there to be a function() or @argument (e.g., User() or @user, perhaps?) that I could use in Sheet formulas that would evaluate to the "currently logged in user".

This would enable more flexible Filters in Sheets that could be supported by Helper columns for evaluating logic against multiple multi-select Person columns.

Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter on this Sheet that shows "Open" (i.e., not Complete) Status rows where the Current User is in either the Assigned To or Consult With columns.

I can't figure out how to do this with the built-in Filter functionality because it cannot do complex AND/OR logic — it's either all conditions match or any conditions match, but not a combo. Filters also cannot do the "inverse" resultset like Reports can, so I don't think I can do an anti-filter for this Sheet filter.

Having an "@user" argument, similar to the existing @row and @cell arguments, would enable this kind of functionality.

I assume this functionality should be possible since Filters can already filter by "current user", which seems to be evaluated when the Sheet loads. The @user formula argument should be able to be evaluated at the same time.

I suppose there could be an issue with Automations/Workflows that would rely on columns that include this argument, since there would not be a logged in user (other than the System / Automation user, I suppose). Perhaps safeguards could be put in place to avoid issues like this, such as a Catch condition that could return some controlled error… but also perhaps this would just always evaluate as FALSE or N/A regardless?

I asked about this in the following Community post, but there have not been any valid solutions offered yet:

Function for "current user" to use in formula? — Smartsheet Community

Without the ability to preview files, the workflow for our support team is clunky, inefficient, and more prone to error. As a result, the support team is looking to move to Jira rather than Smartsheet.

Right now, once you create a Workflow in the Jira Connector, you are not allowed to modify the settings that were initially chosen. You have to create a new workflow and a new grid to feed your report. We should have the ability to change the settings on the workflow, even after it is saved.

With the new subscription model, Smartsheet automatically upgrades a user’s access if an asset or sheet is shared with them using Editor permissions. This behavior should be restricted when the Account Admin has already designated the user as a "Viewer" for licensing purposes.