-
I want to be able to hide my formulas from being viewed when you hover over the cell.
I have a sheet that has a lot of complex formulas and is used (and edited) by many users. When the users are referencing the sheet, the formulas show up and get in the way of reviewing the data. Is there a way I can hide the formulas from popping up when others are using this sheet to edit? All of the columns with the…
-
Use the internal row id
We manually add the internal rowID to a new row by selecting the row properties, copying and pasting it into a field. Then a URL is calculated to provide a link to that specific row. It would be helpful if there would be a way we could generate a hyperlink but access the rowID directly something like:…
-
API Updating Row Format
I was trying to find some documentation on the format string and came across this forum. https://community.smartsheet.com/discussion/13111/update-row-background-with-api I'm trying to update the format of an entire row ( mainly just trying to update the background color of an existing row ). In the forum above it says to…
-
Sync all Projects with a Template
Would be great to have any changes made to a template to also be changed in all sheets that were made with that template. Would make updating projects much easier as currently you have to go through each individual project if you need to make a change like adding a new column.
-
Tabs!!
My team and I are having an absolute blast at Smartsheet ENGAGE! It is impressive and exciting to hear about all of the new features coming to smartsheet soon. If my team and I had a magic wand we would request tabs within sheets to allow for the ability to create a workbook (different/specific data per each tab). Thank…
-
'Save as New' to Multiple Different Locations at Once
Currently if you need to copy a file to multiple different locations you have to do each location individually. Would be great if you could select multiple locations at once to copy the file to.
-
Form timer
Suggestion to have the option to limit the time a form is accessed, from the time the user begins/enters the form. If the form was not submitted prior to the time limit, the form would close and capture answers up to that point. We want to use this feature for interview assessments sent out to candidates. It allows us to…
-
Comparing Cell Contets
Comparing Employee names from FORM (no sign in required) in sheet with the Employee contact list Formula ? I have a master sheet that gathers: training Name and attendees names. i will like to generate the list of who did not attended the training. What is the best function to use for this? Many thanks,
-
Inventory - How to let multiple users claim an item without seeing others' selections?
Hi All, I'm in the process of building an inventory type system in Smartsheet for my company. I have one sheet that tracks inventory for each location. I'd like to have it so I can show employees inventory for their respective location and then if they want an item, click a checkbox and I record their responses. I do want…
-
How to parse a value from a concatenated field?
Hello! I have a column in a sheet that is being populated with multiple pieces of information from Data Mesh. As shown in the example below, the cells in this column contain multiple dates. I would like to parse out a single date from this column (Actual Deadline Achieved) into another column. I don't need the text "Actual…
