-
Need support using wildcard & sumif function
Hello, I have a sheet that's I'm trying to use the sumif function in, but I'm trying to base the criteria on a wildcard. For reference this is a sample sheet I made, and the wild card formula works fine in excel. Essentially, I want to SUM the values in the "RoleValue" column for a specific condition in the Quarter…
-
Advise on Workgroups and access for Groups
I have Workspaces that have sheets containing sensitive information. The Workspaces have Individual access to a few people. With in the Workspace, I created Dashboards, with Dynamic Views. Each is set with specific Groups to access specific information. The users in the groups can not see or access the Dashboards, unless I…
-
How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
-
How to prevent non-admin user from (un)freezing and resizing columns?
In a report, a non-admin user (eg editor) is allowed to unfreeze / freeze and resize columns. Further, these changes are visible to all users of the report, which is causing confusion and a poor user experience in our case. Is there a way to prevent this without removing editor permission from the user? Or for such changes…
-
Australian User Access to Smartsheet Templates?
Hi, I keep getting bounced around by Smartsheet when trying to access the pre-existing smartsheet templates?? I am not located in America or Europe (I'm in NZ but my plan is billed under Australia). It would save me a LOT of time if I could access these again. I have a Pro plan. thanks H
-
Document filtered by form responses
I've created a Smartsheets form. When someone submits the form, I want them to automatically be emailed a document that has resources and links, but the document is filtered to only show the content that corresponds with what they selected in the form. Is something like this possible? What types of documents or automations…
-
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
-
Form stopped working after upgrade
I have a sheet that I created in a previous version, and it had a form. I was recently upgraded to a newer version and now my form is not working. I created a new form for the sheet, and it is giving me an error also. Does anyone know what I can do to fix this? The error says Form Unavailable. Sorry, the form you're trying…
-
Getting Error About Emulated Environments
Hi, I have read the post from 8/21/25. I am still getting the same error. I am setting up a new device and just download the latest version as of 9/5/25. I am using a Eunivon Smart White Board for touchscreen capability. It is running Android 14. Any help would be appreciated.
-
Error on android. For your security, Smartsheet does not run on emulated environments.
Hello, I'm having an error opening my smartsheet app. It has previously worked fine for 2 years, but now it is throwing this error when I try to open it. I do not have an emulated android environment. I am not using a VPN. I have restarted the phone, reinstalled smartsheet. cleared the data and the cache. I can not open…
