-
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…
-
My chart made from a report will not show the date information on the horizontal axis.
When I make a chart from a report the date does not show up. If I make it from a grid sheet the date is there. Using a sheet means I have to update it manually each day. How can I get the date to show up on a chart using information from a report?
-
Admin Control Vs Editor Can Share
Good afternoon, We have a workspace with ONE master sheet that it is crucial no one but the Admins are able to make changes to. We also have other sheets that feed that sheet with automated actions that require users to be able to delete rows and add rows etc However we just try to restrict those users to "Editor - Can…
-
Having trouble linking a sheet. Can someone please help?
Hi all, This used to work for me but now it doesn't. I had sheet #2 below linked to the Employee name and T&L columns but when I was having issues I unlinked it, now I can't get it to work again. Every time I highlight the Employee name and T&L columns in the main sheet, click the Link symbol, then highlight the total…
