-
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…
-
Desired target sheet for "Reference Another Sheet" is grayed out!
I'm attempting to add a reference to another sheet (via Reference Another Sheet), yet the sheet is grayed out. It is in the same workspace, and I have Admin access to the full workspace, including when I check this specific sheet. None of the other sheets in the workspace are grayed out. It has to be something with this…
-
I upgraded from free to pro. I cannot access my sheets or Smartsheet support. Help?
I recently upgraded to a paid Pro account. The day I upgraded I could access everything I had created. I created a new sheet and it put it in a new untitled workspace. When I went back to access my other (previously created) Workspace today, I get a message "An error has occurred in Smartsheet." I've logged out and logged…
-
Smartsheet will not generate my PDF Form
I have imported a fillable PDF form and have moved over all of the corresponding tabs. When I hit save to generate the form it get the following: To generate documents, please add some content to your sheet. Any ideas?
-
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…
-
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
-
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 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?
-
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