-
Naming Manager, Data Slicer, and Table reference functions for formulas, and LET, Unique, Sequence
Excel has leapfrogged Smartsheet in terms of ability to utilize data set, naming manager, dynamic data slicing, Dynamic Table formatting in excel sheets and new formula types LET used with Naming Once as reference, Unique provide back only unique values, Sequence able to order data values via formula, and several other…
-
Autofill child row cells with information from parent rows
Hi! I am trying to get my Smartsheet to autofill information in some cells based on the parent row. The sheet is mainly viewed in card view so when my teammates add subtasks they don't fill in basic info like the team working on the project since that is already in the parent task card. I tried a basic =parent but that…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
Need report that only shows fields that are NOT blank
Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are…
-
Linking Sheets - Master sheet with multiple related sheets
Hi! I am looking to create a master sheet that contains personnel data elements used by multiple teams with different needs. The master sheet should allow data entry of new attendees while also pulling new entries from a related travel sheet. Example: Master Sheet Admin is aware of a new registrant and manually adds to the…
-
What's the best way to have several photo upload sections in smartsheet?
I've been asked by our superintendent if Smartsheet is capable of having a form with the below information: Supplier Invoice Picking List Number Container Open Door Photo Container Number Photo Seal Number Photo What is the best way to capture this information in a sheet/form? Thanks in advance :-)
-
I need to generate a report
Hi All, Myself vinoth, Im working on a manufacturing company which has three departments, i have total four sheets which is Main sheet, Pre sheet, foundry sheet, post sheet, each sheet has his own data like section status and their plan date, target etc, totally around 10-15 columns remain same for all the four sheets, we…
-
How do I report cost changes?
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…
-
Embedded images when Exporting to Excel
Is it possible to export the images that have been embedded into a sheet, when the sheet is exported to Excel. It works when exporting to PDF but not Excel.
-
Column widths should be lockable
I'd really like to have the ability to lock a column width and/or have the column remember each person's/device's last width setting. See: https://community.smartsheet.com/discussion/87852/lock-column-width I work with several sheets multiple times a day that I share with a co-editor. Because of differing screen sizes and…