-
Less round and less cartooney fonts and icons would be easier to rapidly scan and ingest
I see the aesthetics of the new, rounder and softer-edge fonts and icons in the menus, but from a user access and efficiency standpoint, do not like them. I want to be able to scan the sheets in my workspace quickly, and rapidly jump between sheets, and these new fonts and design elements are harder to read at a glance.…
-
Dynamic Drop-Down
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
-
"Use template" - can do 1 at a time and save in a folder, is there ability to do more than 1
We are setting up master templates that we want to use for a customer project. We currently can select to use 1 template and place it in the customer folder. Is there a way to select multiple templates an send them to the customer folder at the same time?
-
Return latest value from another column's latest rows
Hello, I have a sheet in Excel I'd like to move to smartsheet to work with a client's team. The only problem I have is with the fields "Previous Cumulative Partner Discount" and "New Cumulative Partner Discount" as they have formulas that involve each other column in theirs and in Smartsheet it returns the circular…
-
Possible to Undo Sorting from a Day Ago?
Hello all, A colleague asked me for help with something in Smartsheet I could not solve so I wanted to ask for the community's thoughts! A collaborator sorted a sheet based on a particular column (in error) and were unable to undo it. This is the next day and I did not see any way to undo (additionally, there were no other…
-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
-
Links in dashboard freezing
Over the last week or 2, I'm finding that dashboard links 'freeze', ie. stop working after some time, ie. maybe 20 minutes or so after dashboard opened. This is happening with dashboards via the desktop app, and with Chrome and Edge browsers. Once it's 'frozen', as I move the cursor around the page, the links are 'dead',…
-
Cell Changed Color When Formula Updated
I just updated a date cell formula to give someone a little longer to complete a list of tasks and they all turned yellow. It' not a cell filled color because you can't remove it. I have updated this formula before and not had any issues with the box changing colors, so I can't figure out why it's doing it now. It's a…
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
