Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Discussion List
Notifications
Hi All, I have a list of salesmen on a sheet of warranty information. Is it Possible for these individual salesmen to get an email only related to changes made to their customers only? Another way of putting it is can a daily notification email be sent based on the salesmens name in the field once a day to that salesman…
Conditional lock
Hello, I am trying to develop a shareable sheet in which some tasks are listed along a row and check boxes are used to indicate a task has been completed. Would it be possible to lock these checkboxes if its previous one haven't been checked? In this way a process flow would be enforced. Perhaps the solution would include…
Copy Conditional Formatting Rules
Hi, I tend the same conditional formatiing rules across several Workspaces and sheets. Is there a way to copy the rules so I can use them on new sheets? Thanks.
Trouble Following posts
Hello, I am trying to stay active in the community but it is not emailing me when there are new comments. I have checked my settings to verify that my email is correct and I have checked the right boxes in the commmunity section. Is there anything else I need to do? Pic below. Thanks, Brett
Upcoming Webinar Notices
Hi, Is there a way to sign up for notices when new live webinars are scheduled? I love to attend these as I always find them useful, but I am not always able to check the website on a regular basis to see what is coming up and register. Thank you in advance. Nicci
Calendar View
Is there a way to hide the weekends from my calendar and Gantt chart.
Non-Task Project information on project sheet
Does anyone have any best practices for including general project info on the project sheet? It would almost be nice to have a static freeform space to put this info in without having to use the valuable rows at the top of the sheet. We could then query on that information as well when pulling project info for rollups.…
SUMIFS Function with Multiple Column Sum Range
I want to sum values over a two column range using multiple criteria but when I include more than one column in the sum range I get a #MISSING OR INVALID PARAMETERS error message. When I back off the sum range to a single column it works fine. Is the sum range in the SUMIFS function restricted to a single column?
Impact analysis/Traceability?
I'm wondering how one would address this for managing changes to projects? For instance, in tools I've used in the past, I can answer the question "for the tasks/requirements that are at risk/due soon what would be impacted if it weren't completed?" and or "If I change this item, what is the ripple effect to my other…
Duplicate Values Conditional Formatting
Is it possible to highlight duplicate values in a column, as it is in Excel?