-
!! Help share content!!
Guys! The smartest people I know! Does anyone have recommendations or best practices to do or do not do related to sharing materials with customers. We currently share a Workapp with implementation customers. And I do not have a good resolutions for sharing files, videos, user guides attachments either via upload or link…
-
Would auto number duplicate a value if a row is moved to a different sheet?
Hello, I currently have a sheet that assigns an auto-number value for each row. Upon certain actions taking place, this row then gets moved to a different sheet. Because that row got moved, would that free up that specific auto-number value to be used again? I am hoping not as we are looking to use this as a unique…
-
Creating Form where questions will change as per the input from user
I wanted to create a form but i want the form questions to get updated as per the input provided by the user. For example how we have the marketing survey, depending upon the input provided the following question gets changed. Is something like can be done in Smartsheet form as well ? Please help me out or guide me to such…
-
Do not add 10 blank rows at the bottom of the sheet
Please STOP adding blank rows to the bottom of the sheet. They are unnecessary and can cause issues with formulas.
-
Is there a way to set row heights in a sheet back to standard?
I am trying to create a report to add to a dashboard. The sheet I am pulling from previously had several rows expanded due to large comments and the wrap text feature. To pull into my report, and for view of leadership, I would like the rows to be standard for a cleaner feature. Any ideas?
-
Issue with Cell Linking from Metadata to a new sheet in the same workspace
I have an existing workspace for a project. I used the PMO template to create all my workspaces. I added a new sheet w/in the project's workspace and want to link the Project Name from the Metadata to this new Onboarding worksheet. The link shows up but the name does not appear. I've saved, exited, refreshed, etc. but…
-
I have some questions about using smartsheet for managing sign ups for courses
The aim is micromanage / manually edit lists as little as possible. I would like to use automation for situations below: Is there a way to automatically stop/block the option for duplicate enrollments from the same person ( based on email address)? Set a default maximum limit for enrollments? ( stop registration option…
-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
Vlookup
what is the best way to look up between smartsheets and keep the data fresh =VLOOKUP([Equipment ID]@row, {Equipment Tracker H5 RM 8.8.24}, 1, false) Equipment ID]@row = equipment id this sheet {Equipment Tracker H5 RM 8.8.24} = large data block in another sheet this works but will not refresh if data changes help
-
Can I set a cell equal to all data from a column of another sheet?
I want to pull a whole column of data from Sheet1 into a single cell on sheet2. The name of the column on sheet 1 is "Emails". I can't get a formula to work. cell formula something like ={Sheet1!Emails}? I am pretty new to Smartsheet formulas.
