-
Turning OFF Request for Smartsheet license emails to System Admins
We are currently on the legacy collaborator plan. A few weeks ago, we suddenly started getting "Request for Smartsheet license" emails. It seems as if users are able to request a license through the application. We have Account Discovery turned OFF and our Custom Upgrade Screen is NOT Enabled and there is no link to a…
-
Dynamic View - New Item Submission
Under USM and setting up dynamic view for users to edit, comment, etc. without a license - can users also submit a new item through the New Item Submission control turned on without a license?
-
Only Receive Notification When Log in
Hi everyone, I have set up a workflow that is sending notification reminder when task is coming to due. The trigger has been set up as once the status column shown as coming to due then the smartsheet will send the notification. But the user will only receive the notification when he open the sheet. If he doesn't log in,…
-
Counting with multiple criteria
I dont know what im doing wrong here, im trying to count anything with Mentoring and if Q1 is found =COUNTIFS({RelatedGoalWoW}, HAS(@cell , "Mentoring")) + COUNTIFS({Quarter}, HAS(@cell , "Q1"))
-
Is anyone experiencing issues with Completion % not accurately rolling up to the parent row?
We use a change cell value automation to update the standard % Complete column to 100% when a task status changes to Completed. This used to work perfectly, however, recently we noticed that the % Complete for the parent row in our project plan (e.g., Planning, Execution, Closing) is not recognizing the cell update. Our…
-
API Support to Create and Update Sheet Filters
Hi Smartsheet Community and Product Team, Our team relies heavily on Smartsheet for project management and dashboard reporting in our enterprise environment. We recently encountered a challenge where a critical dashboard widget depends on a "Milestones" filter (a shared filter that shows rows where a checkbox column is…
-
Language Translation Process
Hi Smartsheet Community, We are trying to develop a process within Smartsheet, that essentially allows us to create a repository of processes in English, and once english is entered, it then translates into French, German, Spanish but all on separate sheets. I was thinking about reports, but it doesn't really give us the…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
INVALID OPERATION ERROR - HELP NEEDED
Thank you in advance for your help. I actually worked with Smaartsheet's AI Help to generate and work through the formula. I have checked it twice and still get the same error message. Here is the formula: =IF(AND([Tester ID]@row = {DE2ET Tester ID}, [Scenario ID]@row = {DE2ET Scenario ID},…
-
👋 Hi everyone, I’m happy to be here!
🏥 Where I work & role I’m a Grant & Development Coordinator at a community-based organization that is also a certified culturally specific behavioral health provider. Our work blends behavioral health, community health services, public health programming, and a cancer support center. 📊 Background & Smartsheet experience I…