-
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…
-
Ignore #DIVIDE BY ZERO in Sheet Summary SUM formula
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…
-
Smartsheet Removing Zero
I have a course code 30657.201930 that I am pasting into a cell that is Text/Number. It drops the last zero, so it says 30657.20193, not 30657.201930. I tried adjusting the decimal points, but I cannot get the zero to stay. I'd like to keep the ability to paste the course code from another document, but I want to be sure…
-
Print directly from attachment view?
Hi Smartsheet, Not sure if this is possible but it would save some clicks if there was an option to print directly from the Sheet Attachment view. Screenshots below.