-
New Here; Automation question
Hi, I'm excited to start using Smartsheet to manage all of our workstreams and related tasks and issues. I was wondering if there is a way to automate the setting of one field based on another, so a row update? E.g. I mark a task Complete and it moves it to the (card) list Completed? What I'm finding in automate workflow…
-
Increase width of task in Calendar view
Is there a way to increase a width of a task within Calendar view depending on effort/time So in the image provided - the task on 17 will take the whole day but the task on 18 will take only an hour but both take the same amount of real estate within the date.
-
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…
