-
Recipient information
Hey, I wanted to send a web form link to a group of my customers. For this reason, I have set up a group in Group Management. After sending this web form link to this group, I have noticed that recipients can see each other. I wonder is it possible to hide this information, so that each recipient is unable to see other…
-
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…
-
Printing Gantt View
I am having serious difficulty printing a Gantt view. Despite following advice from Smartsheet, I cannot get the option to select specific rows, so it constantly prints hundreds of rows. Also despite selecting 'Fit to page' etc it will not print on one page (even A3) without making it so small as to be illegible. I am also…
-
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…
-
Dateonly rounding issue
I'm trying to calculate networkdays from system generated date created. I used the dateonly to pull the date out of the system date created but it seems to be rounding up at some designated time of the day which causes all concurrent formulas to be off
-
Renaming columns
Even though I have admin access to the sheet, I still do not have the option of renaming columns?
-
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…
-
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.
-
Formula for changing words to numbers
Hi, I've created a survey with a likert scale, Rarely, Sometimes, Often, Very Often, Always, which is captured as options within one column, and need a formula that when someone enters Rarely in the survey, a separate column in the sheet shows a 1, Sometimes would should a 2, Often 3, Very Often 4, and Always 5. I then…
-
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…
