-
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.
-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…