-
Enable Cross Sheet References to work with Sheet Summary
I check with Smartsheet to see if this was possible and it is not. I've submitted an enhancement request. Support suggested I post the idea to the Community so folks could "like/vote for" the idea. If by chance someone knows how to do this...reference sheet summary values from another grid, or between sheet summaries on…
-
Is there a way to have an alert triggered hourly and send to a client (non-licensed user)
We are have created a sheet to share with our client and have added them as an editor but for some reason it will not allow me to send an hourly alert to them when we add comments to the sheet. I am trying to avoid an alert that is triggered immediately when comments are entered. I am able to do this on a different…
-
I'm receiving an unparseable error with this formula? What do I need to adjust here?
=IF({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "3. Moving Along", "Green", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "2. Needs Monitoring", "Orange", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "1. Needs…
-
How to remove unwanted items in the "View By" list in Card View?
I need to simplify the number of items shown in the "View By" list in Card View. Does anyone know how to remove the unwanted items? Deleting the columns in Grid View is not an option as they have a legitimate usage for planning. Also, is there a way to re-order the items in the list?
-
Smartsheet forms and non-users
I use Smartsheet forms a lot with non-users. I just created a new form and shared it via a QR code with a non user on their mobile device, and it came up with a prompt to login into Smartsheet. To my knowledge this is the first time this has happened for me. Has there been a change? Can non-users fill out forms without…
-
Pro Plan connected with another users
I run a business and cooperate on a B2B basis with 10 different companies(sole proprietorship).I want to make it so that everyone who wants to cooperate with me will buy access to the Pro Plan Can I do that? Do I need to buy Pro Plan licenses for everyone if the companies I work with have buy themselves? The issue is that…
-
Automating blueprint to create templates under existing workspace
Hello everyone, I currently have a blueprint that holds a bunch of templates. These templates get created under existing workspaces, meaning, i do not want a new workspace to get created. Currently, we're using the manual approach. when a request for these templates come in, we go into control center, and we manually…
-
Permissions on sheets using control center
Hey Everyone- I'm using control center to create sheets of tasks lists. I've got the project owner on several tasks and I created a report union-ing all of the tasks. (So far everything I'm describing is out of the box capability with SS CC). My project Owners want a report that show all of the tasks on their projects.…
-
Conditional Charts in the Dashboard
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
-
Reports Error message- User is not assigned to this application
Hello, I published and shared my report, but am getting this error message . The publish Read only Full - Access Control screen shot is as under . What is the issue here and how can I get the user access to my report?