-
COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
Hi everyone, I've had a look in the forum threads to try and find an answer already, but not sure what I'm trying to do is like-for-like with some of the suggestions. BACKGROUND: I'm helping colleagues with aggregating some of the data in their deployments sheet, which they use for managing and tracking their events, the…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
Is there a way to show which reports are built off a sheet?
Hi there, I saw some discussion about this a few years ago, but as an admin, is there any way for me to create a list of reports that use a given sheet as a source? For example, for sheet A, can I pull a list of all reports that use Sheet A as a source? Thanks! Jackie
-
Modified "Report" for client
I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit. I was successfully creating cross…
-
Has anyone tried to create a trivia game using Smartsheet?
Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other people wrote. I thought about using DynamicView to allow only view access by user, but I'm wondering if I can be more…
-
I am able to see the folders, but not the sheets within those folderrs
Hello Team, I previously created a few sheets using my corporate email. However, since my corporate account no longer has access to Smartsheet and I have already used my trial, I am unable to view the sheets stored within those folders. Could you please advise on the best approach to regain access to these sheets?…
-
Can you re-trigger an approval workflow?
I have a couple different scenarios that I've run into. The first is that the end user is saying that the approval request isn't coming to them, so they can't approve anything. The second scenario is that the approval goes to a person that they wrongly identified and we need to re-route the approval to the appropriate…
-
Dependencies visibility in project sheet
Improve the visibility into the task dependencies in the project sheet via function/formula or inbuilt capability to display dependent task names
-
Dashboard Help- COUNTIFS, Checkboxes and Hierarchy
I am trying to make a widget for a dynamic dashboard that shows how many child level 2s and if the "Closed?" box is checked or not. I would like to make it a pie chart if possible. The level column is measuring by Parent/child hierarchy with the formula =COUNT(ANCESTORS()) + 1 Thanks!