-
Understanding "When rows are changed" workflow
I have setup an automation that copies a project row to another sheet when the project phase is changed to Waiting to close. The copy is working but it's creating duplicates and I'm wondering if it's a bug or I am misunderstanding how the function works. Based on the wording I would expect this Workflow to trigger when the…
-
Pairing 2 items
I have a set of managers managing different departments. I want to ensure that when a manager is selected, perhaps from a dropdown, it corresponds to the appropriate department. In other words managers and departments should be paired in 2 separate columns or otherwise. Is there a way to do this?
-
Calculate average workdays it takes for certain requests to be complete.
Will preface this by stating I have to reference another sheet that I do not have the ability to edit that sheet's information. I'm working off a sheet I created as a formulate reference sheet used for a dashboard. So when creating calculations I have to use formulas that reference the other sheet with the request…
-
Contacts and Contact Lists
When you set up your My Contacts list you provide the First Last name, then the email address. That list is then used in contacts Sheets, Raid logs, etc. and when you search in the contact field of a sheet (whatever you choose to call it) the first name last name shows up and you can select that resource for the item. Part…
-
Unique Row Identifier For a Workspace
Hello, I need to have a column for all sheets in a Workspace which has a unique ID for each row. I know that I can use the system generated auto-number for the column however I need to ensure that the ID in the cell is unique for all sheets in the given Workspace. Any suggestions?
-
The behavior of Duration, Start Date, and End Date fields when dependencies are enabled
Thought sharing what I learned about editing these fields in a sheet vs a report could be helpful to others. Please note that this only applies when dependencies are enabled on the project settings. On the sheet when they are all blank, indicate any 2 and Smartsheet calculates the third After there's already data on these…
-
Alert Someone Notifications not Working
Hi! I am running into an issue where my 'alert someone' notifications are not sending. I have a column that is formatted as a contact list, and my automation is set up to alert the email chosen in that contact list. However, the emails are not being sent. When I test it with myself, I DO receive the alert via email, when I…
-
Date duration subtraction
Not sure how to explain this. I have attached a photo of how its done in Excel and the actual smartsheet. I have a migration state date of July 28th and several tasks after. I need the cell in start time to change if I decrease or increase the lead time. I cant figure out any formula or if its even possible. Excel Example…
-
Schedules
I have created an appointment calander based on 30 min slot . User can click on calender timeslot and then can book,,, Timeslot example 8:00 - 8:30 8:30 - 9:00 .... 16:30- 17:00 So the problem is some users wants to book for 1 hr... but they dont want to click two times 30 min slot .... Is thr any possibilitits in…
-
Automating Responses Between Two Smartsheets
Hello, I have two sheets that I am trying to connect in a specific way. The one sheet, Config Mgmt, has a Labeling Progress column with two dropdown options and six additional columns where users can input text. The other sheet, Labeling Sched, has a Document # column where users can input text and a Status column, which…
