-
How can I view 2 sheets at the same time? Goal is to make sure the rows are the same.
I am using the PMO template provided by Smartsheets. Under Project Level, I have a Template folder that I use to create new project folders (save as new). When I make a change to the project plan in the template folder, I would like to view the project plan in the other project folders. Right now, I would just like to be…
-
IfError returns "incorrect argument"
Hi, I am trying to find values that exist between two Smartsheets. When it does, I should get a checkbox, and when it doesn't, I would like the checkbox to be unchecked. If I use: =IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0) I get "#No Match" when a value…
-
Finger gesture scrolling.
We issued Surface Pro 7+’s and Surface Pro 9’s to managers to use in the field now that Smartsheet has become the main system for work orders and assignments. For some reason, when using the browser or app on these devices, we are unable to scroll by touching the screen and swiping up and down or left or right. We can…
-
Copy/Paste is failing somewhat randomly
Hi, In recent times, my copy/pastes sometimes don't work. Most frustrating. One consistent workaround is to log off from SmartSheet and then log on again and then immediately do the failed copy/paste. It seems to be triggered by attempting to copy the value in row 1 down to every row in the sheet. Once triggered, even the…
-
Column Descriptions - Here at last
We have at last now got the ability to as a Description ToolTip call it what you want. Pity it is not picked up automatically as the Default (Editable) Help Tip in the Forms.
-
Is there a way to make part of a workspace public?
I am not sure if this is possible, but want to see if it is or isn't! I have 8 team members. They each have their own workspace, where they add new sheets to act as a new project. These sheets/ projects are private to themselves, however, on the team dashboard, we are able to see the title of everyones sheets, status of…
-
Unique Information in Smartsheet Form
Hello! I am working on a survey in Smartsheet that will request updated/missing contact information from our customers. In some of the questions, we would like to show the customer what we have on file and then have them update if needed. Is there a way to pipe this information into the survey that would be unique for each…
-
Archiving- Quick Way to Turn off all Automation Workflows
We have hundreds of project sheets created and archived every year and when archiving, we have a process of turning off all automation workflows so that they are not triggered once the project is completed. Some of the sheets have +10 automations on them. It would be great if there was a toggle button that would turn off…
-
Poor Man's Datamesh
Prior to getting Datamesh, I devised a solution to transfer data from one page to another, without having matching columns. This process uses an intermediary sheet. It's kind of a pain to set up, but it works well and requires little to no maintenance. I still find some very small use cases where this comes in handy.…
-
Dynamic View is Empty
I have a dynamic view pulling from a Sheet. I have a formula on my Contacts column to only populate the rows that a person was approved to work. Will this affect how my Contact is used for Dynamic view? Because I set it up like normal and nothing is displaying for me. Sheet Dynamic View Settings. Pulling from correct…
