-
Merged: Better filter function
This discussion has been merged.
-
Merged: Option to include Children rows in Filtered results
This discussion has been merged.
-
Merged: Archiving- Quick Way to Turn off all Automation Workflows
This discussion has been merged.
-
Referencing a sheet that has non-working days
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…
-
Expand The Manage References Pop-Up Menu
When managing references in a sheet, the menu that pops up to begin editing/duplicating/deleting cross-sheet references is incredibly hard to work with. The box that pops up does not allow the user to expand the bounds of the menu - vertically, horizontally, or diagonally. Ideally, building the menu out with functionality…
-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
Countif with contains
I want to count the number of times the word Booth is contained within a row for each of my vendors on my sheet. There are other words in the row such as cancel or no show. I have tried =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @cell) and =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @row) and…
-
Locked column changing to date column type
Looking for some help, I have a sheet where I have locked a column to a contact list type. When I log back in to Smartsheet at a later time, the column type is still locked, however it defaults to a date type. This is happening on another column as well which is not locked due to requesting updates from those assigned in…