-
Contact List matching
Hi, I have been struggling for awhile that the contact list in a sheet, including automation, doesn't sync with My Smartsheet Contact list…how do I edit the contact list in a sheet? TY
-
SORTING AND FILTERING DYNAMIC VIEW
Up until yesterday (11/3/25) I was able to click on the top of a column and sort my column. This worked for me yesterday morning but when I went in to work in the afternoon I was not able to sort columns anymore. Also it seems my filters are not working. I am not the admin for this sheet but the admin is saying nothing has…
-
Card View rearranging order
Hello. I have a sheet that I would like to use in Card View. In the setup, things appeared to be working as normal: I have parent and child rows, in the order that I wanted, and when I switched to card view the hierarchy of the cards was the same in both views. However, in my testing something has changed. Now when I…
-
Best way to manage multiple users
Hello, The company I am with has an enterprise license for SS. We have a task where we are storing updates on a spreadsheet, as they evolve, within multiple departments. This has created much discrepancy within the data. I would like to lock it down to about four people being able to enter updates while others submit…
-
Adding cells with IFERROR blanks
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…
-
Adding a last comment column into a sheet
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
-
How to regain access to a sheet?
I was the administrator of a log sheet, and the owner was an employee who left the company. One day, the sheet was deactivated, and no one has access to it. How can I recover it?
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…
-
Automatic WBS Numbering
We have a work around but it takes multiple helper columns and complex formulas. You need WBS numbering 1 1.1 1.1.1
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…