-
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.
-
Randomly Pick contracts for reviews
Hello, I am working on a process that will help our providers due peer reviews. I have built a Blueprint that makes the review sheets with all the information they need. Need help thinking of a way to determine who the Reviewer should be. Basically I have a list of all the Providers and need to put one of them in my intake…
-
Sequencing automations with no condition/trigger overlap - clearing top row after an automation
I'm hoping you can help! TL;DR in the weeds - I'm looking to use a change in the sheet to trigger an automation - but only act outside of the actual trigger TLD;DR big picture - I actually simply want to run two automations sequentially. As far as Smartsheet can tell they are entirely disconnected. (Their connection runs…
-
Scheduler in Smartsheet
I am designing a Scheduler in Smartsheet. It will be location and then have a central report view to see the whole schedule. Has anyone done this in Smartsheet before and can share some lesson learned or other knowledge points that would be helpful?
-
How do I remap my Smartsheet Form?
I have a Smartsheet form used to collect and manage training requests. The form is set up with a client selection dropdown, followed by additional fields specific to each client. For instance, selecting "Dignity Health" in the client field triggers the appearance of Dignity Health-specific fields such as Client Host…
-
Toggle Column Filters
It would be a time saving feature in place of the existing conditions feature function to have the option of a toggle on/off column filter feature that provide at the column a quick filtering options based on the column types (date - date filters, text - text filters) and include a text field to type in a value; and the…