-
Merged: Make Cell Usage and Formula Usage Counts Visible
This discussion has been merged.
-
Formula Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
Sheet Vs Workstream permissions to external users
Hello, My non-profit has some auditors in the office today and they are reviewing some of our project plans as part of the financial audit. To be most efficient I have been asked to give them access to a particular project sheet. However I can't see to be able to share an individual sheet (the 'share' button is greyed…
-
Merged: Dynamic View - add sheet attachments
This discussion has been merged.
-
How do I stop rounding?
Hello! I'm trying to enter tax information for different counties. I need this amount to be 2.0145%, but it keeps rounding to 2.015%. I've added two extra decimal places, and it still rounds to the thousandths place. How can I get the full number to show?
-
Allow display of destination sheet full name in the Edit Automation dialog when moving copying rows
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is to move or copy a row. 2) The name of a destination sheet that is selected is longer than what displays in the Edit…
-
Time Column Property
Similar to the other column properties, but restrict a column to time (whether 12 or 24 hour format) and be able to generate formula based on beginning and end times and other entries.
-
Formula for rolling up children status to parent rows
Hello, I am trying to simply roll-up my children status' to their parent row. When using this formula: =IF(COUNTIFS(CHILDREN(), @cell = "Complete") = COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> "")), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress")) I receive…
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Creating Expense Reimbursement Request
I've been tasked with creating an expense reimbursement request for our employees to use. We currently use an Excel spreadsheet but then have to manually get approvals. We're trying to move that to Smartsheet to automate the process. I can create a very simple form for 1 expense item. However, sometimes an employee will…