-
Feature Request: Choosing Cells for Dashboard Widget
Choosing cells to add to a widget is rather difficult. It would be nice to be able to use Control and Shift with the ability to select an entire row of cells when generating a "Metric" widget. When you click the row on the far left, you cannot utilize CTRL or SHIFT to select multiple rows. Additionally, I have built in…
-
Alert Notfications Now Sending to Multiple Users
Hello, We had a strange issue creep up late last week. On two of our sheets we have it configured to alert a user if their name is checked. It's been set up this way for years, but since Thursday of last week multiple users are getting alerts for actions unrelated to them. For example, this morning user 1 was notified of 3…
-
Pull Data for Current Month
We are a construction contractor that uses smartsheet to track all of our projects. I am trying to set up a dashboard to show the current months quotes and current months jobs sold. In the past I have just run a report and then put the date between (1st and last of the month). This gets me the data I am looking for. But I…
-
Setting milestone to Finish date?
Is there any way possible to set the milestone marker to the Finish date in a sheet? Right now, I'm still having to manually set the Duration column to "0" to get the milestone icon, but even when I do that, the date of the milestone gets set to the Start date.
-
Countif comparing months in a date
Hi I'm trying to figure out a countif formula to count up the number of times dates in 2 columns are not in the same month but struggling to figure it out. Can anyone help? I've attached a screen shot to show bit more clearly what I mean. Basically I want a count to show the number of times things were not prepared and…
-
User Group Sheet vs. Workspace Sharing
I have a Workspace that has 1 sheet in it. First: From the sheet I shared the sheet to several individuals and 3 user groups. All received 'Edit - Can Share' permissions. The individuals can access the sheet while those in the user group cannot. Second: From the Workspace I shared the entire Workspace to the 3 user groups…
-
Sharing Edit Permissions to a Group
I set up a workspace with 4 sheets and will soon include reports, dashboards, etc. I created a group and added my team members to the group. I then shared my workspace with the group, granting them edit/cannot share access. I have instructed them to click on the 'Work Account' button at the log-in screen. My understanding…
-
How to send a form triggered by a cell changing?
Hi, I have a Smartsheet that contains information about different pieces of work. Each row is specific to a piece of work and it has multiple columns, one of these is Status. I display this as a Kanban using Card view. When I change the status of an item to Completed, I want to automatically send a form to a contact in one…
-
No longer receiving reminders/notifications
I have not received reminder emails or notifications in the app for any reminders/alerts since 5/22/2019. I have checked my notification settings, my spam folder, I keep running tests, and so far I can't find an easy solution. I've attached screenshots that show my notification center, card view showing active reminders…
-
How can I create drop downs with selections based on a previous column?
For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise. For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples, bananas, grapes, oranges, etc.…
