-
Rotating Assignee on weekly basis
I’m building a Smartsheet to rotate 30 assignees on a weekly schedule, with each task spanning one week. The formula I created is returning a ‘#UNPARSEABLE’ error. Could anybody advise on how to correct it or recommend an alternative formula that supports this rotation? Any visuals appreciated as well.
-
Sheet Statistics
Something that quickly shows # of rows # of columns # of cells # of cross references # of unique formulas I'm sure there are other metrics that would be nice to see quickly Close to breaking warning or notification to sheet owner Could be part of Work Insights but all together, like a table, and update immediately.
-
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…
-
Merged: Applying Grid View Conditional Formatting in Bulk
This discussion has been merged.
-
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…
-
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?
-
Permit formulas in columns with the "Restrict" value toggle enabled
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
-
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…