-
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…
-
Sheet Filters on Reports
Sheet filters are extremely useful ways to view sheet information, it would useful to have the ability to select a sheet filter when developing a report to avoid having to duplicate the filter setup process.
-
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…