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
GDPR - Data Storage in Europe
I have recently started using SmartSheet and have today given a presentation on wha SmartSheet an offer us as a business. My bubble was well and truly burst when my colleagues started asking about data security based on the impending May change from the Data Protection Act to the General Data Protection Regulation. Are…
IF AND formula for RGY
I am working on a project plan that needs to show the "health" of each task based on the finish date and the status. I've been able to do a formula that checks the status and then selects the correct RGY and I've been able to do a formula that checks the finish and selects the correct RGY but I've been unsuccessful with…
Send Reminders to Multiple Contacts
I want to send reminders to multiple contacts listed on my sheet at the same time. Contacts are listed in separate columns on the same row. This is for use in a template, so the names in those columns/cells will change. Smartsheet will not allow me to select multiple contact names (from columns) in a reminder. It does let…
The option to change parent row calendar colors when dependencies are enabled
I have several tasks in each of my sheets that I want to see in a report for major milestones. I want the different tasks to have different colors. Right now it is possible to change the color of children rows on the Gantt Chart/Calendar view, however when dependencies are enable, it's not possible to change the color of…
CountIF between 2 dates
Hello! I'm trying to count the number of children whose "Final Approval Date" is between 6/1/17 and 10/1/17. I don't even know where to start with this formula. I know I've got my weekly totals like this: =COUNTIF([FINAL APPROVAL DATE]:[FINAL APPROVAL DATE], AND(@cell <= TODAY(7), @cell > TODAY(-7))) Any help is…
"Publish User" when using Microsoft Teams.
When a user makes changes to a cell in a smartsheet from inside a tab in Microsoft teams (either in the Teams app or in the Teams Web Client), when looking at the Cell History the cell changes are logged as belonging to "Publish User". Is this the expected behavior or is there another way to make sure that the changes are…
Forms and formulas
Hello, I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not finding any info on this but then again I am new to the site. I would also like to know…
integration with TrackingTime
Hi All I've been using Smartsheet with TrackingTime and it's been working really well.... until yesterday. Now it just seems like they are not talking well with each other. The task name are not porting to TrackingTime and the icons don't change when tracking. Anyone else having this problem? Tjamsl
Date Format
Hi I need the date to be in the format of yyyymmdd so that I can concatenate with other cells to form document name. Otherwise, it would be manual process for me to go through every single documents to name them. Currently my settings is set as English (UK), the date format is dd/mm/yyyy. Is there a formula to convert this…
Changing outlines of Gantt chart bars
Hello, I would like to change the colors of the outlines/lines around the bars for sub-activities in the Gantt chart. I was able to change the fill color but the outlines are still light blue. Is there a way to change the color of the outlines? Thank you very much! Kind regards Ulrich
