-
Best Practice
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…
-
Issue with WorkApp Attachments?
Is anyone else experiencing problems with users not being able to add attachments to sheets or reports in WorkApps? Users that gain edit access to sheets and reports to edit and attach documents stopped having that ability late yesterday.
-
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),…
-
Freeze Rows...
you can freeze columns, but not rows, which makes literally 0 sense. It should be a basic function, have seen people talk about this years ago and its still not a functionality…
-
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.
-
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…
-
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…