-
Linked Cells that are not read-only
We keep our master calendar/schedule in Smartsheet. Every year, we create a new copy of the sheet and insert dates for the new year, but the majority of the other content stays the same. Is there a way to do a cell linkage where the linked cell in the destination sheet IS editable? For example, for each row on the…
-
Dashboard Chart Formatting
I currently have a chart on a dashboard displaying information from a certain range of data. If I change what data is being selected, it reverts to default formatting (e.g if I select different data for a stacked bar chart, it reverts to a non-stacked column chart and all the colors per series return to default colors as…
-
Security on Column Level and per User
Hi, Could we have a validation or anything that prevents some columns to be updated by a specific user? Not all sheet, just some columns. Thank you.
-
Saving spreadsheets in workspace
Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, then click the small "floppy" on the top left, close the page and then, when i come back,…
-
Enhancement request - smarter autofill for dropdown menus
In a column using a dropdown list of options, it would be great if autofill was smarter - specifically, if it would suggest options based on any word in the list of options, not just the first word. For example: Typing "West" should bring up options like "Broadway Street West" or "Northwest Broadway" not just "West…
-
Referring to Adjacent Row
I am using the following formula in Color column to shade every other row in a sheet: ROW 1: No formula ROW 2 = IF(Color1 = 0, 1, 0) ROW 3 = IF(Color2 = 0, 1, 0) I have over 1,000 rows. This works fine. However, if I insert a new row, I have to drag the formula from the row above all the way down to the last row the fix…
-
STS dots
Is there a way to add another color dot to the Drop down, or select a new one with 5 colored dots for the STS column?
-
Row Color For Easier Visuals
Good afternoon, Is there a setting that we can set up so that every other row is a different so that it is easier to follow data across all columns when looking at the sheet? Would like every other row to be gray to tell difference from the white rows. Thank you
-
Viewer Send Email and Add as a Comment
Is there a way that someone who only has Viewer access can send an e-mail to Smartsheet which adds the content of the e-mail as a Comment? As far as I understand, they do not have the ability to add Comments directly, since they only have Viewer access.
-
SignNow integration
Anyone successfully integrate SignNow with Smartsheet? What can be integrated? Can forms be autogenerated from data in Smartsheet, and form creating/emailing (using email, named, etc. in Smartsheet) and signing via SignNow be recorded in Smartsheet automatically (e.g., activate merge in smartsheet via a trigger, which then…