-
Referencing another sheet using vlookup
Today's my first day using Smartsheet; I referenced another sheet for columns that I needed. Now rows that are not found in my specified range are auto populated with "#NO MATCH." I need guidance for making the "no match" blank. I tried an if statement but still having the same issue.
-
Successor Column
Hello, Could the SmartSheet community get an update on the successor column from the products team? I believe this was first requested a few years ago in late 2015 and has been by others multiple times since then. Thanks, Riley
-
Graphic Archive Numbering Concatenation
I am trying to figure out how to connect a number of columns to output a number into a new column. We have a need for a graphic archive number that could combine all these elements. artist name, creation date, and a numerical counter. So, if Joe Artist makes a new graphic on August 1st, 2018, and its his twelfth graphic of…
-
Multiple Selections from a List
I have graphic tracking system in development through smart sheets that would benefit from being able to tag multiple elements of a graphics content for flexible searching. For example, a graphic that shows a sunset over mountains with a lake in the foreground would be tagged in a graphic content column with outdoor,…
-
Allocation meeple appearing without any concurrent task
Hi, I got a mysterious meeple over-allocation icon that I have check numerous times did not any have a concurrent task. As I interpret the allocation icon, it means I am doing many task as the same time on which numerous occasion I can clear it by changing the schedule or dividing the task to subtask or phases with…
-
How many cascading multiple sheet dependency can smartsheet can do?
HI, Its me again doing cascading dependency on different sheets. I tried 2 cascading project sheet dependency and it works. I try doing 3 tomorrow but a question lingers: How many cascading multiple sheet dependency can smartsheet can do without any issue? Thanks D Micu
-
Day totals for multiple child rows?
Is this a bug? Why can I not get the parent level row to show day totals, for all of it's child rows?
-
Notifications not including attachments or comments
I set up a notification alert to send an update once a column is checked as "done", and was to include all items in that row, including attachments and comments. However, I am not receiving the comments and attachments. Please help.
-
Smartsheet and JIRA integration
Hi, I have two questions related to Smartsheet and JIRA integrator and I'd like to know if somebody here could help me: ** Question #1: Is it possible to insert a row (automatically) within a parent structure from JIRA integration? For example, suppose I have this smartsheet: Marketing Team Tasks Task 1... Task 2... Task…
-
Question re: image attachments when using Smartsheet for Outlook Add-in
I use the add-in and whenever i am moving an email to Smartsheet, it automatically selects all images in addition to any PDF or other attachment. My signature line contains 6 images and so every time i add something through the add-in, it tries to pull these same 6 images. I must de-select them each time. So here's the…