-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Should I use a Report or a formula?
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a formula.
-
Embed certain columns on another page?
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira tool to document and report statuses, would like to embed this gannt view but exclude the column with notes so it's a cleaner…
-
Comments In A Report
I am managing several sheets, and want to create a report for myself and the team that logs or captures all the comments that are associated with the sheet/tasks. I am struggling to find a proper way to include the comments (visibly in a report) Thanks for suggestions.
-
Notification when comments change
I am trying to get automaically notified when someone adds a comment in the System comments column (circled in green). Thoughts?
-
Feature Request - Comments and Attachments trigger 'modified' column value
I'm trying to create reports that will show my projects the changes to their workspaces over the past day. I thought a report would do the trick, and I'd just filter by modified within the last day. However, reports don't always catch what you're looking for, like ALL the changes. Report WARNING, the "modified" system…
-
Last Modify Date based on Comments
I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.
-
Feature Request: Ability to @ someone and they get notified
I would love the ability to be able to @ someone when making a comment, and then they get notified in and email that I mentioned them. This would really help when I am making comments and I want people in my team to see that comment (without having to use the notifications feature because it isn't that great because it is…
-
Unified task list
Hi everyone! I started using Smartsheet to control all the projects in my company(aproximatelly 9 projects). Some of them have confidential parts, but they also need colaboration of other employees. Can I create a unified task list for each person so that they can view and update only the task related to them, withou…
-
@Mentions needs login
If I mention someone in the comments, does the collaborator need to login and be shared to be notified or even notified without an account, as with updates requests?
