-
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…
-
Returning multiple results for a cell with multiple values
I have two sheets: one is a form collection table and the other is a reference table. One of the fields (Code) entered in the form collection table will determine who is responsible for the request submitted. The Code cell can have multiple values (separated by a comma and space). It is possible to have multiple people…
-
Merged: Mandatory fields in update requests
This discussion has been merged.
-
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),…
-
Best Practice Inquiry
Good morning, We have an expense report that I pull from our system 2 times a month and put into Smartsheet. I have about 100 Department IDs I share it to split between different 10 bureaus and 4 centers. I am trying to find a good way of splitting up the information. Currently I have 10 grids for the different bureaus…
-
Merged: Freeze Rows...
This discussion has been merged.
-
Automation: Not Triggering when Box is Manually Flagged.
I have a simple automation but it never actually triggers. Alert 2 people (names cut from the image) if the store closed check box was flagged and the upgrade date is in the future. It never runs when I flag a line item - but the test sends it out.
-
Will Table view eventually totally replace Grid view?
Is it in Smartsheet's roadmap to stop adding functionality to grid view and only add new features and functionality to table view? Is the long-term plan to make grid view obsolete?
-
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…
-
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.