Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Merging the text of 2 cells into 1.
Hello, is there a way to merge the text of 2 different cells into 1 please? I have tried several versions of this but I get different error messages. =(([cell]1) &” “&([cell]2) Thankyou.
Creating multiple row entries from one submitted web form?
Back with (what I believe to be) another obscure question that I don't know how to search for nor find an answer to. I'm attempting to work around the issue of not being able to have more than two dates in a row - we run news stories to multiple audiences so would prefer to have one row for each story, with up to ~10 date…
Send emails with live links other than web links
It would be great to have the hyperlink feature not just be limited to web sites. If I could put a link to a file located on my network, I could then send a notification or send a row and the email that would be delivered would allow me to click on that link to open the file or network location locally. Ex: A cell has a…
Importing contacts with .CSV file
Hey, I am unable to import .CSV file with cotacts information to My Smartsheet contacts. I get an error saying: "The file "test.CSV" is not a valid contacs CSV file. No E-mail column was found. Please verify that the file was properly exported." I have followed the instructions and used proper column names A, B, C (First…
Automatically copying a row to another sheet depending on if a certain cell matches the sheet.
I was wondering if there was any way of automatically moving rows of information depending on information found in a specific column. For example. I have one sheet that lists tasks that have been done by employees and the job number that they were working on (i.e. 165-07). I also have other sheets that provide the…
Tracking benefits for funders
We are wanting to use Smartsheet to track the benefits of our corporate funders so we can easily see who is taking advantage and who isn't ... and use it as a reminder to get them to take care of the benefits. We have about 8 - 10 benefits per vendor that needs to be tracked. Suggestions for which template would work best?…
Fetching Parent Cell value for Children Cells
Hello, I would like my Children Cells to fetch their value from the Parent cell. Is it possible? Will it be possible soon? NB - I do not want to fetch the value from the "cell reference" of the parent ("=[Related Invoice]1 ")
Best/Good Practice request: True up miscellaneous tasks
Looking for better practices than what I am currently doing. Example: On Tuesday, I expect to get something from the vendor. Usually that means end of day for planning purposes. I put that in the schedule as either a milestone (0 duration) or a full day task. On Wednesday, Admin Albert needs to spend less than 2 hours on…
Formula to include new data added to my sheet
I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula on Row 1 starts from row 16 to give me the total I want into Row 1. My formula in…
Renaming columns
Even though I have admin access to the sheet, I still do not have the option of renaming columns?
