-
Controlled data: Create Rows but not Edit OR Edit Rows but not Create
prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.
-
VLOOKUP to another sheet using images
I love the new VLOOKUP functionality and am using it to try to reference IMAGES that I have stored in another sheet.However, I noticed that SmartSheet only pulls in the image name (example: imagename.jpg) and does not actually show the image. This would be so useful to actually pull in the image itself as a…
-
Adding more rows or columns
Hello, I have 25 rows for different initiatives. Each initiative is shared with multiple depts (up to 10), and each dept needs to document a few outcomes for their initiative. In your experience, shall I add 10 depts X 3 outcomes so 30 columns to each row? or copy the initiative into 10 rows and assign one dept per each…
-
Natural Language processing for dates
Natural Language Processing to set key dates using the same conversational tone from comments. specify time with descriptions like "Tomorrow at lunch" to instantly populate Thursday's 12 p.m. deadline as a date.
-
Making Column Required
I have done some searching around the Smartsheet community but couldn't find a conclusive answer. Can I make a column required so that if it is left blank and try to save the sheet will error out asking me to enter data. Thanks in advanced. Devin
-
Hidden or Blind Comment Feature
I would love the ability to have a hidden or blind comment feature for end-users to provide comments or feedback without being able to see the comments posted by other people. This would be especially important for intake sheets so the committee members can have conversations about the request in the comments section and…
-
What is the best way to deploy a new version of a form, using the same link?
I have created a new sheet and form for my users to submit tickets through. I'd rather use the same link as the previous sheet, if at all possible, so I don't have to worry about users not saving the new link properly and not being able to access the new sheet. I tried to save over the new sheet with the old sheet's name,…
-
Multi-select dropdown column to pull single value in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…
