-
How can I make my automation stop updating once a column is checked?
I am trying to set up an automation so that when a column is checked it copies to another sheet. The problem I am having is that anytime anything in that row is updated it is continually copying over. I want it to be a one time copy because I then have it mesh to another sheet.
-
Automation Isn't Working and I'm Stumped
Okay, I am stumped. I am unable to have a simple automation run on my sheet, much less a complex automation. It used to work, now it doesn't. In my Personal Settings, I have all the boxes checked in the Notification Preferences, so I don't understand why I am not being notified. Any help from the smarter folks out there to…
-
Workflow Condition Field won't auto populate contacts
I have created a workflow to alert a person the day a task is due based in part by an Assigned To field. When setting parameters in the flow, because the column is set as a Contact List, I would expect all of those fields asking for a name to autofill. That has not been my experience. Per the first screen shot you'll see…
-
Only Display Rows Selected by the User on a Dashboard
Hi, Can the following be done within Smartsheet? I have an inventory sheet containing a list of projects. I need to display this sheet on a dashboard (via a report?). Each user viewing the dashboard only cares about certain projects. For example: User A only cares about projects 4, 9, 15, and 23. User B only wants to see…
-
Dashboard automatic updates
Hello, I am looking for a way to send a weekly message to a group of shared users to view the team's portfolio dashboard. Currently I have a scheduled report that is sent weekly, I want to do the same with the dashboard. Thanks Michelle
-
Symbol Data Type
Hi everyone i´m trying to use symbols with formulas =IF([KPI REQUERIMIENTO]1; <=2; "Green") and i´ve been getting #INVALID DATA TYPE as result. Been testing with Text/Number and symbol column type and keep getting this error Which column type should i use to get this formula working? Thank you.
-
Hiding dropdown values on a form
Hi Smartsheet users! I have a sheet for selling fruit to two different customers, which includes a column called, "fruit type" of the dropdown variety. The values it contains are, "apple, banana, pineapple, orange, lemon, mango". Both customers interact with a custom form made for them. Both forms have the "fruit type"…
-
Suggestions for display of a calendar
Hello, I am working to create a call room reservation request system for our hospital. Smartsheets is working wonderfully for this, I'm just stuck with one little dilemma. The people who review registrations, like to be able to view the month at glance for all the rooms reserved. The screenshot below shows our current…
-
Update Request/ Notification dilemma
I am using Automation send Update Request 2 times with someone who is not a shared user. The first time I send an update request it works just fine, they only receive 1 email. However the 2nd time I send an Update Request it sends 2 emails, 1 is the Update Request I want and the other is an Update Notification. This person…
-
I want to create multiple sheet linked with Main sheet and it should get updated automatically
Hi , I want to create some sheets linked with Main sheet based on Project lead criteria and Child sheets should get updated when we make any changes in Main sheet. Example : Main sheet has 12 columns and I want to copy 5 columns from that sheet to another based on condition as Project lead "ABC" and also if any update done…
