-
Saving Sheet changes
Hi everyone, someone on my team brought this to my attention and i want to see if anyone else has experienced this. I have a sheet where the 90% of the data is entered via a form. the remaining 10% of data is filled in afterwards once some additional information is received. my team member says that he is 1000% certain he…
-
Copy/Paste Not Working Today
Today I copied data from and Excel spreadsheet and tried copying it to corresponding cells in a Smartsheet grid and the paste function didn't work - no data was pasted. I've copied and pasted data into sheets many times in the past and have never encountered this problem until today. Is anyone else having this issue? Can…
-
Specific Mailalerts (triggers) not working today
Hello everyone Today - like many days before - I added and edited data im my sheet and (tried to) trigger workflows. All of a sudden today mails are not delivered like they used to all days before. I changed nothing severe (only moved the sheet to a workspace, but already undone it). It only happens within one specific…
-
JOIN Command Issue
Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell. =JOIN([Comments #1]1:[Comments #2]1:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1,…
-
Meeting agenda item reports
We're piloting the use of the template set including the past & future agenda item reports. The issue is the reports aren't pulling the correct data. I added a column to the meeting sheet that is the meeting date (function pulls it in date format from the parent row where the date is entered as text) so each child row is…
-
SMARTSHEET MERGE, HIDE SPECIFIC COLUMNS
I built a Fund Allocation Request form that makes people produce PDF for printing at the end of the process. To be able to produce the PDF, I use Smartsheet Merge. But I ran into an issue of confidentiality. Since the form is a finance thing, we don't want the users to see how much funds are requested for each items. Yet…
-
Cell Linking Within Same Sheet
Hello... is there a way to link the value of a text-based cell to other text-based cells within the same sheet? I have a project plan template in which there are several fields in my "Assigned To" Contact List column which will need to be populated with the same person. Instead of even copying/pasting, I was hoping to…
-
Automatic Convert Email Address to Hyperlink
Anyway Smartsheet can recognize the value in a cell as an email adreas and convert it to a hyperlink? Based on value in a cell in Sheet 2, an email address is "pulled" from a cell in Sheet 1. However, its text, not an email address contact/hyperlink. Ultimately, I need to have a way Smartsheet can use the email address to…
-
Pulling Email Address from Another Sheet but as a Contact
In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in two cells in Sheet 1. Now Sheet 1 shows the course code in Column 2, the program leader's name is Column 3, and the email…
-
Image Widget Linked to a specif set of rows in a sheet
Does anyone know if there is a way to link an image widget directly to a selected amount of rows in a sheet? I currently only see the option to link to a full sheet, but want to direct the user to a certain section of the sheet.