-
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…
-
Can I use a sheet to create a purchase order form?
I'd like to create a purchase order form that allows users to select items from a drop-down list and display the quantity and total of each item. I have created a sheet, but all of the items in the primary column do not appear as a dropdown.
-
Activity log is now available in table view
October 01, 2025 The activity log is now available in table view for all customers. You can access it by selecting the View activity log button on the right side of the toolbar. Learn More Note: This launch is limited to activity log in table view. Activity log will also be released for board and timeline views in the…
-
Merged: Copy an automation from one sheet to another
This discussion has been merged.