-
Edit recurring report email
I set up a report to get emailed to a few people once a month. I would like to edit who is receiving this report, but I can't find the report schedule. I found a few posts about this but clicking on File—>Send as Attachment just allows me to set up a new schedule. Can anyone help?
-
Filter using Current User not showing all data
A filter I've been using is suddenly acting oddly. I have a list of associates with Year, Manager, and 1-over Manager columns. My filter looks for Where Manager is one of Current User OR 1-over Manager is one of Current User. The result shows correctly except it only shows the results for 2023 and 2024, not 2025 or 2026.…
-
Sheet fields missing from form creation.
I have an index doc sheet with 4 columns of information to pull in onto a master sheet. I then have other fields on the master sheet which I need filled out by using a form. When I go to the form creation, it only lists 1 of my fields from the index doc sheet and master sheet to select for the form. Why is that and why…
-
Table View Matching
I'm doing a column match in table view. Here's the results I got: When Source Sheet primary column is a calculation = No Match 2. When Source Sheet primary column is manually typed = Match Nothing else is different, is this a limitation that you can't match on a calculated field? The column types are both Text/Number.
-
Formula to Convert Scientific Notation to Numerical Value
Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…
-
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
-
"Rolling" cleared text - how to manage
I have a sheet that others update as and when they can as well as reporting by set dates. A checkbox is used to mark that the material is cleared for reporting and this is the criterion that pushes the information through to dashboards and paginated reports. Managed previously with a single checkbox that was cleared on a…
-
Autocomplete data entry like Excel
I simply want to have Smartsheet autocomplete my data as I enter it in a cell as Excel does. Is there a way to turn this on?
-
Merged: Freeze top row
This discussion has been merged.
-
Automatically copy one row when it is the end of the week or end of the month
Hello, I have created an automation to copy a row at the end of a week or at the end of a month so i can keep a log of all the calculated KPI's. This has been working for the past year. Unfortunately it stopped working a month ago for no specific reasons. Does anyone know what could be the reason? Thank you in advance for…