-
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…
-
Is there an easy way to see all the cross sheet references for a given sheet
I'm looking to scale back the number of cross sheet references I have in a sheet as I've hit the new 100,000 cell limit. I'm hoping there is a statistics or some information that I can look at to see where all the references are and possible cell counts that are being used so that I can make an informed decision on what…
-
Filter for Assigned To in multiple columns
In my sheet, I have a few columns of assignments for different tasks. Is there a way to create a filter which will show any row that has a specific person assigned, but also must have a Check Box checked, in a specific column? I know there is the At Least/All toggle, but I'm looking for something that will offer an option…
-
Dashboard Location
The dashboards are no longer on the Home page. Does anyone know where we can view them?
-
Is searching a column not available anymore in Safari?
Typically to find the row I want I click on a column header and then press ctrl + F and it automatically scrolls to the row where it finds the search term. Now when I press ctrl + F in Safari it just does the browser search, which can't find the cell. It still works on Firefox. Is there a way to get this back in Safari?
