-
Collect cross sheet formula help
I want to pull through the task name in one sheet where the check box at row is checked into another target sheet. This is what I though the formula would be but I get #UNPARSEABLE as the error. =INDEX(COLLECT({Task name}, {Stage check box}@row , 1)) Um, help please?
-
Linking another Sheet
Hi All, I am having some challenges which I was hoping someone might be able to help me with… There is an existing Smartsheet that a project team uses to display new product introductions. As this sheet is updated in real time and I am not in that team, I can't add fields that I want to track into that sheet; however, some…
-
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…