-
Auto Email Notification
We are using the automated email notification to notify all shared users of changes to a sheet on a weekly basis. The email received by the person who made the majority of the updates does not show their updates, yet these are shown on the email received by all other shared users. I've not come across this issue previously…
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
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…
-
Email to smartsheet add-in: can rows populate at the top of the sheet?
Hi I have recently discovered the Gmail to Smartsheet and found it works really well for my work! I just have one question though - when I populate a new row in a sheet through the gmail integration the new row appears at the bottom of my sheet rather than the top. Is there a way I can set this option for it to appear at…
-
Is there a way to collapse the rows in a Gantt chart?
I'm trying to take a spreadsheet and present it in a way that has one row for each category of item, and then multiple cells across that row to represent the emails sent in that category. This is a calendar of sorts. Each category would be associated with a color. (That's the part I have figured out.) I saw Smartsheet's…
-
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
-
Alert or notification based on date
I am searching for way to create an notification or a reminder based on a contract's expiration date. I have checked SmartSheet's help data but have found no way to make this happen. Can anyone assist me with how to do this .... all we want to be able to have, is when a contract is within 3 months of its expiration date, a…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
COUNTIFS and with 2 different values in same column?
Hi there, I'm trying to create a formula to count when 2 different types of activity in a column ("Key Initiative" and "Initiative" have the value "Complete". I've been trying different ways to organize COUNTIFS to solve the problem, but I'm getting either "0" or #Unparse as a result. The most straightforward formula I've…