-
Email notification with more than 1 row
Hi there, I have set up a rule to send an email notification when there is any update in a row. When there are more than one row, the affected row details are shown in tabular format (same as it is in smartsheet). My sheet has around 30 columns and I wish to show all the 30 columns in email notification. On receiving email…
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Database of information from one sheet to another
Hi all, I have a sheet that is a "database" of about 400 records. I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate. Is this possible? Would VLOOKUP be a solution? I've read a few forum posts that said that…
-
Renaming of attachments?
Good morning, I did a search in the Community, so apologies if this has already been addressed. Is there a simple way to rename attachments? We have several Word/PDF attachments and need to rename them to our internal naming convention protocol. The only way we've found is to download the document, rename, upload and then…
-
Using Star Symbols - Two star is missing
Hello everyone, I can assign the column type of symbol and select the 5 star type. Oddly, the two star selection does not display. (See screenshot). If selected it also shows no stars. I tried recreating the SmartSheet but the experience is the same. Any ideas on fixing this?
-
To do list with extended tracking functionality
Hi there! We are collecting todos in a "topic list" connecting each task to one particular team member. Every task has a due date. Do you have a routine to track the development of these tasks? I.e. a task has been finished by me but now there are new challenges awaiting the next team member with the same task. I can just…
-
Auto notification. When attachment downloaded
Hi. - I run a sheet with form to collate drawing data. the original form user uploads a drawing and this populates the sheet. the auto alert tells the other client (via email) of an attachment available for download. The client then downloads the attachment. Is there an auto alert to advise me - admin -that the attachment…
-
Sumif using a variable
Hi, I have a simple sumif adding values from column Estimate based on some text being present in column Artist. The result is all the time allocated to a particular artist. =SUMIF(Artist:Artist, "Alex", Estimate:Estimate) In order to make this more compact I would like to have a pull down menu with all the artists names.…
-
Print Card View?
Is there a way to print card view, or even share a link of it to a non-SS user? Love the flexibility it's given me to sort in new ways, but can't figure out how to share it with anyone else.
-
SmartSheet Calendar App
First off - love it. Totally has changed how we are communicating with internal project teams and external vendors. What isn't working that great: Speed - super slow to access Email Comment Notifications: it would be great if the email notifications could show the comment and thread (if any). Nice to be able to get a quick…
