-
Modified report based on when comments were added
I am trying to figure out if it is possible to either create a report or even have the modified column updated based on when a comment/attachment was added. Right now, the modified default only updates when someone updates a cell in the row itself. Please let me know if you know a way around this. Thanks!
-
Pie Charts
I was eager to checkout the recently released Smartsheet Charts, I have produced a couple of Pie Charts based on some real time data but seem to have found that limited funtionality/formatability (e.g. Not able to re-position labels) restrict their actual use, please see screenshots below. I wondered if it's just me or…
-
comments notification email not functioning
My team has been using an automated email to a group of users when certain conditions are not met. When the automation was first created, the users were able to respond via comment, then the assigned person from my team would get an email notification, in addition the notification within SmartSheet. This functionality no…
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Smartsheet integrating with gmail add-on error
I get an error message randomly when I get to the final step in adding an email to my sheet. It says - Your changes could not be applied. Please check “. This doesn’t happen all the time and is not consistent.
-
Delete multiple comments?
Hello, all! We created a copy of a 2020 sheet to make a new one for 2021 because so many of the tasks are recurring; we're merely updating assignees and task dates in most cases. However, we're now left with several comments and attachments throughout the sheet that we need to delete because we copied the full sheet. Is it…
-
Health of Task or Project using % Complete & Finish Date - Sanity Check
I found something close to what I am looking for here: NEED HELP: Health Formula based on start date, end date, and %100 complete needed. — Smartsheet Community This formula doe s a great job of flagging the dates in relation to time left. However, I am looking for a health check that can take into account both percentage…
-
Sharing Recommendations and Limitations
I'm rolling out a new process with a client and constantly finding areas where I need to use a work around, only to find that solution won't work in another aspect. For example, I have one sheet with sales data that needs to be updated constantly by the sales team, however, I don't want them to have access to the sheet,…
-
Current User/Alert Someone Automation
Hi, I have an automation that any time a comment is made a contact listed gets an email using alert someone. The issue is the email links to the report but the report is so large it is difficult to then find the comment that was made. Is there a way to make the link or report more defined when they go to it? Or at least…
-
Comments feature - turn off forwarding capability for "viewer"
We shared a sheet to a viewer and it appears that not only can they view comments, but they also have the ability to forward them. We'd like to avoid the forwarding, if possible. Is there a way to turn off this feature?
