As part of a process I am trying to populate the next person responsible for a task and send the notification to them but struggling to get teh contact details from the row below. How do I do that?
Can you explain further what you are trying to do?
Do you want to copy the contact details from one row and use them in a cell in the row above, like this:
So that you can then use the details in an automation for the top row?
If so, the formula you need in the cell I have as Column 3, row 1 is
If you drag this down it will become
=Contact3 in row 2
=Contact4 in row 3
The row number always being 1 number higher than the row you are on.
You will need to replace the column heading with your own heading, and if this has a space in it, use  like:
I am running VLOOKUP to bring a picture located in a specific row cell over a new sheet cell. The issue is that picture comes as a text (picture name). My ultimate goal is to pull that picture into a dashboard, when trying that, just the text comes If I bring picture directly from the smart sheet where picture is located…
Hello- I am trying to remove the item names from the right side of the gaant chart. Is there a way to get rid of those and preferably add other column information instead? I see the settings pop up but there is no option to get rid of those labels. Thank you!
I have a report that is filtered by a particular folder within a shared workspace... everytime I remove items from that folder the report no longer watches the folder, and it turns into individual items within the folder... Is this common behavior? Has anyone else experienced this behavior recently? I want the subfolder to…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.