-
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.
-
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…
-
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?