-
Ability to change the primary column at a later date
It would be convenient if you could change the primary column at any time. I have an existing sheet and would like to switch the primary column to a different text/number column. I know there are workarounds to get the end result, but it would be super slick if you could just change it by editing the column properties.
-
Archiving Rule in Control Center Not Working As Expected
I have several completed projects located in an intake sheet that I would like to archive. I created an archive rule for projects with a status of "Ready to Archive" to move to a separate workspace. I also checked other freeze & disable features for items. When I tested one project, the only thing that worked correctly was…
-
Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell. This is what I've tried: =COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7) Thank you for any help!
-
Allow ISO 8601 Date format for dates (YYYY-MM-DD hh:mm:ss)
ISO 8601 is an international data standard and a part of two national standards in the United States. "The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred…
-
Ability to Select Default Opening view
It would be fabulous to have the ability to select a tab or area to open automatically when I open Smartsheet, specifically my favorites tab. This way the projects I am focusing on or touch everyday appear automatically when I open the product. Could be an option in my profile settings? One less click and can keep views…
-
Why is my WEEKNUMBER returning two different weeks for the same day?
I have a function that counts if a form was filled out at least once a week. They are supposed to have from Sunday 12:01 am to Saturday 11:59pm to finish the form. I have 5 submissions for Sunday 01/05/2025 and two are reporting to the wrong week. How do I fix this?
-
Multi- Row Solution
I am trying to create a workflow for an expense report that allows me to turn it into a PDF. Is there a way to utilize the generation of multi-row so I do not have to create columns for each individual expense?
-
Merged: Find and Replace Function in Formulas
This discussion has been merged.
-
Merged: Customizable Sheet View(s): save specific hierarchy layout
This discussion has been merged.
-
Expand All/Collapse All Default View Setting
Would like to have the option to set the default view for a sheet with many parent/children rows, so that each time the sheet opened that default view would be shown. In other words, I'd love to have the default view at each opening of the sheet to show only the parent rows without having to choose collapse each time.