-
Countifs within date ranges
I have - a column containing weekdays, that spans a complete school year. a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs from the start of the date range, but only up and not beyond today. Any help appreciated!
-
Advanced Notifications options - add scheduled notifications.
I like the improved Notifications functionality and would like to add one more suggestion. Can you add a "Delivery" capability so that the frequency/Date/Time for the notification can be customized? This is similar to the existing functionality in SmartSheet Update Requests.
-
COUNTIFS with a date range and symbols
This is probably a no brainer for some of you with a lot more experience so I apologize ahead of time. For argument's sake, I have 2 columns. Column 1 we'll call DATE, column 2 we'll call SYMBOL. I'm looking to count the number of "GREEN" symbols that have a date greater than or equal to 1/1/2017. When I use the following…
-
Conditional E-mail Notifications - Attachments?
I absolutely love the new Conditional Notification feature from Smartsheet. Thank you so much! I do however, wish that you could view the attachments in the e-mail. This was part of an existing issue we had with some of the automated e-mails we set up before (either through other companies or via notifications) If there is…
-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…
-
Status Changes
Hello, Is there a way to run a report that will tell me all of the changes that have made in my sheets? I know I can go in individually and do that highlight changes command, but I have so many sheets it is impractical. I would prefer to accomplish this in a report that pulls in the data from all of my sheets. - Adam
-
Automatic calculation of lag time
Hello Smartsheet community!! I hope someone can help me with the following question: I have 1 activity that depends on another BUT does not necesarly needs to start right after the predecent activity finish. I know that the duration of the activity is 2 days, and the exact date when it has to be finish. Is there any way to…
-
New notification feature doesn't send an email to all the users specified
I set up a new customized notification yesterday and set up the email delivery for myself and 3 other colleagues. However, I was the only person to receive the notification email this morning. Did I do something wrong or is this a programming issue? I have included a screen capture of the notification set up. Thanks.
-
Merging all sheets
HI, Is there any possibility to merge all sheets altogether? For example - I have 3 sheets name January 17, February 17 & March 17. Headings are the same but data is different. How can we merge all three sheets while exporting it into MS excel? Regards,
-
Sum children networkdays
I am working on a complex formula that I won't get into the details of but I am having a problem with one small part of it. I need to check the children of a parent row to see if the task has already started but not ended. Column names are {Actaul Start] and [Actual Finish]. Then if this criteria is met I want to get the…