-
Resource is picking up time not showing in a sheet
We have time shown in resource view for an operative, the sheet from which the allocation is coming from doesn't have any sign of the said allocation. Everything is largely complete with most things marked to 100% and complete, the rest of the project is on stop yet resource viewer shows the allocation. Does anyone have…
-
Preferred Contact List dropdown best practice?
Is there an easy way to populate the preferred dropdown choices in a Contact List? If I had 50 (the limit), mentioned here https://help.smartsheet.com/articles/504619-column-types#contactlist do I need to select them one by one? No import? I tried commas and semi-colons in a list, but that didn't work. I tried populating…
-
What are the capacity limits for the rich text widget?
Is there a limit to the number of characters a rich text widget can contain? The client wants to type information directly into the rich text box instead of using a sheet or form yet doesn't want to lose previous information.
-
Automatically Collapse Empty Card View Lanes
Hi All, I have been foraying into the wide world of SmartSheet card view. I was wondering if anyone knows if it is possible to automatically collapse the empty lanes? I have lanes that I have "listed" in the drop down that I anticipate to use in the future, however many of them are blank at this time. It also produces a…
-
Best practices when dealing with large amounts of reports
Good afternoon everyone, I was curious to know what everyone's best practices are when it comes to managing a large number of reports and how to implement holistic changes? We have dashboards designed for multiple locations and in those dashboards are reports that are filtering content from a sheet, filtered to those…
-
Copy row from ingest sheet to specific category sheet
Process starts with a form, and information is added to main sheet. The forms allows the user to select a category and want to copy that row information to a separate category sheet and keep the information in the main sheet. Do not want to copy row information multiple times to the category sheet (this is the behavior I…
-
HELP!! How do I Merge Excel Smartsheets to an existing Smartsheet?
I had changed cells by mistake, deleting a lot of column information. Smartsheets sent me the smartsheets via excel. I tried to merge to the existing sheets that lost the data. It does not have any of the attachment, comments, or reminders. How do i do this???
-
Setting up an Inventory Management Process
I do a daily count of inventory in a storage room and submit the count of each item via a form that feeds into a central sheet for each location. I'll refer to this at the "COUNT" sheet. Each item has it's own form, for example "Gloves". This means each day there are new row for "Gloves" with the most up to date count in…
-
Editing Forms - Mass Edits and Exporting?
I have fivesheets, each sheet is fed from about 20 forms. I'd like to be able to mass edit these forms because 90% of their fields are the same. Instead I'm stuck manually adding every single field to every single form on every single sheet. That's over 100 edits for a simple change! I'd also like to mass export the URLs…
-
Move row automation/ Advance options
Hello, Is there a way to select the fields (columns) one wants to move to another sheet thru Move Row automation? One can use Advance Options> Column Visibility to select what to show for Alerts/Reminders and even in the approval workflow but it's not an option when moving/copying rows. Thanks