-
Cloning Filters
Hi! I am setting up smartsheet for different departments in a company. I have 10 filters in one sheet and need the same filters for a different team on another sheet. Is there a way I can clone the filters just as in conditional formatting to be used in other sheets instead of repaating the same process again? Thanks!
-
Please move "Refresh" to the toolbar, and give me a keyboard shortcut.
I would really like to see "Refresh" added to the toolbar. I think a lot of other people would too. Synchronizing changes with other collaborators in near-real-time relies on hitting refresh repeatedly. It's hidden behind a drop-down. Getting new users to refresh (or save) consistently as a matter of best practice has it's…
-
Project Management Best Practice Ideas?
Good Morning Smartsheet Community! Does anyone have any best practices / suggestions they could share for multi-project management ideas? We are currently using a Report that pulls rows from the "Assigned To" column across all project sheets in specific workspaces; However, while it serves the purpose, it isnt visually…
-
Form Field to Comments
Is there a way to have a field on my form that would input the text to the comments for that row?
-
How to highlight a date in a column based off of another date
Id like to highlight Column (Date Sent to Owner) in reference to Column (Due Date). If we hit the targeted Due Date, before or on the day that it is due- I would like Date sent to Owner to be highlighted green, if I we exceeded that date or it is past due, I would like that to be highlighted Red. Is this possible or is is…
-
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
-
Linking from a sheet that's reached the 5000 row limit
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximately 100 field employees. My sheet is up and running and is being rolled out to a limited number of supervisors during the…
-
DataMesh not finding cell links
I am having issues with DataMesh, as it is unable to look up the values between the sheets. I checked some of them manually, and the numbers exist on the target sheet. I also tried to export into Excel and test this formula. Excel required a re-format of the numbers (text to number format) before it was able to…
-
Has anyone used Tempus by Prosymmetry?
My Smartsheet contact had recommended Prosymmetry to me for my companies resourcing and time tracking needs, and I'm doing due diligence and vetting. Can't find much information on this company including their seed funding or VC info. Has anyone else used this tool? What has your experience been?
-
Number of rows in a sight.
I have a sheet with just under 500 rows, with information about buildings. I have a report to format a concise list of information to publish, and have several widgets, including links to the maps that have some of the source data, on my sight. The Sight only displays the first 150 buildings, with a pop-up link to the…