-
"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.
-
Reference links break in formula
I want a formula that can reference updates on another sheet and add the info onto my sheet. The other sheet is a schedule that has job locations and PTO time for each individual on each day of the week. I want to know the dates that each individual on the sheet has an upcoming PTO, and for my sheet to update with 'PTO' on…
-
Table View - Activity Log
Hi there, is there a way to make sure activity log is running when people open the new "table view" in Smartsheet? At the moment, the collaborator shows up as an icon in the top right corner, but there is no record of the collaborator viewing the sheet. If opening in grid view, the activity log works as expected. many…
-
Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…