-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
-
Role and Permission Changes with the new USM
Hi There, I am looking for any description on Roles and Permission with the new USM. Are there any changes on the Roles and Permissions compared to the former license model? As an example I am especially looking for the User Management Roles (e.g. Group Admin, Resource viewer, Plan Asset Admin) as well as the Workspace…
-
Smarter SmartSheets
Hi Smartsheet team and community, Is there a chance you could consider adding these two features to make our workflow smoother? 1. Add Instructions to "Request Updates" Automation It would be incredibly helpful if we could include a short description or set of instructions when sending an “Update Request.” That way, when…
-
Auto Number Primary Column
Of the various data types a new column can use, it is logical that the Primary Column can only be Text/Number or Auto Number. However, Auto Number is not an option as of now. I would like to request having Auto Number be an option for the Primary Column. There are many applications of intake or request sheets are used…
-
User Activity
I've been wondering about this for awhile, is there a place where you can find your user activity for any comments, or questions you've helped answer etc.. I know there is a Activity in your Profile for badges and achievements but im looking for your activity within the community. Ex: I've answered a question, and now its…
-
Force refresh of page if User uses back button on Browser
I would like to find out how I can force a page refresh if a user press the back arro / button on their browser
-
Dynamic View Missing
The Dynamic View button is no longer in the ribbon of my worksheets. The leads indicating where it can be (Launcher icon etc.) are missing. Even if changing the view from Grid to Table, I don't have it as an additional item on the "More" dropdown. I have always had access to it. Where has it gone to?
-
Viewers and Permissions after new pricing model
I have provisional users who, under the legacy model, were unlicensed users with editing permissions for workspaces. I’ve now changed their role to "viewers" and assigned editing permissions to specific workspaces, aiming to maintain the same editing experience as before. However, they cannot edit fields within tasks or…
-
Phone number validation won't allow all zeros
Hi- We have been using a SmartSheet Form for a while, and users have been able to enter 000-000-0000 if they don't know a person's phone number. However, over the past few days, it appears that the phone number validation field will not allow all zeros any more. Is there a way that I can change this? We would like the…