-
Sheet formula to access members in a group
I've created a Group and can track assigned tasks in a Resource View with the group dynamically. Is there a way to access the group list in a formula on a sheet? In my sheet, there is an "Assigned To" column which is a Contact List type column. The cell can be assigned to group members and non-group members. The next…
-
Gantt Chart Settings Not Applying
Hi! I am trying to create a dashboard that has multiple gantt charts. I want the gantt chart to display from the current date, which is already an existing setting. I've checked the box on both my workspace, and the reports I am using on my dashboard, and for some reason the current date does not display. Has anyone run…
-
New sheets created in one browser tab not available in other browser tabs.
When I create a new sheet in a different browser tab - you know, because we can't open multiple tabs anymore - the sheet is not available in the other tabs. I went out of the folder and back in to give it the opportunity to update, but it didn't. It does not see like the browser tabs are working very well. Maybe we should…
-
Invalid recipients of notifications removed from SmartSheet sharing access
I'm using alerts/notifications and getting false positive alerts about invalid recipients who happen to be on vacation with automated out-of-office replies. I get an alert as shown below with steps to change permissions for including the inactive users in the automated notifications that were originally set up. The funny…
-
INDEX-MATCH Showing Wrong Information
I am using the following to pull a course title from another sheet: =IFERROR(INDEX({SubjectCourses-Titles-Credit}, MATCH([Subject + Course]31, {Subject+Course}), 3), "") It has worked fine with several course codes (Subject + Course), but when I enter an incorrect course code (i.e., it doesn't exist, such as HOS 419), it…
-
Status symbols that are color-blind friendly
Hello! I'm using the Red, Yellow, Green, and Gray status icons in a report that I present during my weekly manager meeting. Unfortunately, our CEO is color blind and has trouble seeing the colors. Would it be possible to add additional status icons such as these but with different shapes, such as circle, square, triangle,…
-
Resource View / Completed Projects
If a task/project assigned to a person has been checked off as 100% complete before the assigned deadline, is there a way for the Resource View to update in order to show that person being available during that time, without going to the sheet and updating the duration/end date of the task? This way that person could be…
-
How do i get count of values against specific names
I have three columns . What i need is a formula to get details - If range responsible person is selected, what is the sum of target for each person seperately and in a similar way on the actual column what is the sum of actual by each person. The result i am look for should look like the one below. responsible person…
-
Any Potential for Linking Reports to Sheets?
Hello, I wish there was a way to link a report to a sheet - does anyone know how to do this, or is it possible? I am hitting my link capacities for our production reporting, but what I really wish I could do is to sum a qty in a report and then graph it on a dashboard. Is there anything in the works at Smartsheets…
-
Update email address for contacts does not update shared sheets automatically
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific contacts are not updated with the new information. Let's say that I have already shared or assigned tasks to these contacts. I…
