-
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!
-
Merged: Increase Row Limit in Worksheets
This discussion has been merged.
-
How to ignore #DIVIDE BY ZERO in SUM function?
I have a formula in my template Sheet Summary that I need to add the dollar amounts in the Annual Cost (Original) column. However, some of the rows will generate #DIVIDE BY ZERO. I need this formula to add only the cells that have a dollar value in them and to ignore the #DIVIDE BY ZERO. The formula I currently have in the…