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. Archived 2017 Posts
Archives for January 2017
Discussion List
Adding free collaborators to resource view
Hi, in oredr to plan 3rd party resources who don't have SmartSheet we wonder if we can invite them as free collaborators to be able to have them assigned to tasks and check their resource allocation. On a broader level it can be imageined as "virtual users". There is no need for them to use SmartSheet anyway but we must be…
Efficient way to make same change in multiple sheets?
I've created a Project Template that has been used for 40 Active Projects. When I am make improvements to the Project Template (e.g. Added Column, added Row, Dropdown List change, Conditional Formatting addition, creation of shared Filter...) is there any was to propogate the improvement to the 40 active Project Sheets? I…
How to calculate number of days overdue on a task
Hi, I am new to the community. I would like to create a status field that changes color based on number of days overdue. Is there a way to calculate the number of days overdue in smartsheet? Thanks in advance! Susanna
Average formula for cell values calculated from another formula
I'm using the SS Jira connector for Jira and have create a template for my team to use. As part of this template I want to calculate the % completed field based on the task's status (the built in % complete of the gantt project only work at the parent level after manually inputing a value for the child task). I've been…
Smartsheet not triggering zaps
Smartsheet's tech update this morning wasn't very clear about what problems the app is having. Has anyone else experienced problems with the Zapier integration. Adding new rows is not triggering new zaps, even if I manually select "Run" from the menu.
Publishing SmartSheet schedule to Shared Exchange Calendar
I want to connect a SmartSheet project calendar to an existing shared Exchange calendar that is available to everyone in our organization. The goal is to maintain a project schedule in SmartSheet (with all of its great features and viewing options) but make it readily available as a shared calendar to Outlook users so they…
=SUMIFS, Please help..Formular works on a business collages sheet....
Hi Team, This formula works on a business collage sheet, he reffed me to smart sheet and has been helping me build my sheet. this returns #Incorrect Argument Set....whats missing =SUMIF([Value of Jobs]2:[Value of Jobs]60, Result2:Result60, 1, [Sold Date]2:[Sold Date]60, MONTH(@cell) = MONTH(TODAY(), SUMIF([Value of…
Smartsheet is very SLOW today
Smartsheet is very slow to load, type in a cell switch sheets, pretty much everything for all of our users. This started somtime around 10:30AM CST today. Is this on our end or Smartsheets end? Thanks
Single update request to multiple people failing?
Anyone else seeing this? A customer reports that when she send a single UR to multiple people, the first person "wins" and the others are locked out. I have not been able to reproduce it. Previous behavior: 1. Send UR to multiple people. 2. Each gets email. 3. Each tracked separately The customer says it does not work that…
Enhancement Requests: Community / Help search
The number of threads on the Community has grown since i became active. In March 2016, there were about 2300 threads. There's more than double that now (466 pages x 10 per page) I'd like to see some improvements so I can find things more quickly. The search I am talking about is either here: Thanks Craig