-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) is…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
Can not move my sheets/reports between folders
Im trying to create new monthly duplicate folder with all shared links we are using for our data project , for some reason i can not move sheets and reports between folders , only to workspace that not commonly used by us Anyone is facing the same , your support is appreciated Thanks in advace
-
Item Changing with New Information Need Reporting Help
I have test for items a,b,c,d and a report that is pulling data from those tests. Occasionally I'll have an item that will turn to a version 2 now considered a2. Column information wont change. Now there will be an a, b, c, d, and a2 rows. What should I do to pull the correct information to my report now that a (the…
-
Approval Requests - edit and delete like Update Requests
The Approval Request feature (Approval Requests | Smartsheet Learning Center) is lacking some of the functionality of the Update Request feature (Update Requests | Smartsheet Learning Center). I want to edit or delete an Approval Request that is pending on the row, the same way I can edit or delete a pending Update…
-
Text input field above the column names in grid view
I would like to see a text input field above the column names, similar to other spreadsheet software. I prefer using that over inputting directly into the cell, and it would allow me to work just a little more efficiently.
-
Two Sheets in One Report using same column
I have two sheets referenced in a report. Both sheets have column "A" which is a date column. Since Sheet #1 is the source, I would like to only pull column "A" from Sheet #1. Sheet #2 references(using formula to index match) Sheet #1's column "A" just for information. It seems when I use only Sheet #1 in the report, I can…
-
Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
-
Is it possible to copy an automation workflow from one sheet to another sheet?
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need to manually set up the workflow on my new sheet. Thanks!
-
Dashboards and Presentations
What are your best practices for using the dashboards for presentations to executive level? I am having difficulty displaying a dashboard within a PowerPoint presentation and screenshots are just not the best or most effective. Thank you!