-
Emailing report if cell is changed.
Is there a way to have a report email only if a cell is set in a certain way? I have a report that I want to email but only if there the box marked review is checked. Is there a way to do this?
-
Alert with custom time
On the Alert feature, will there be a custom feature when the reminder or e-mail be sent out? Some staff that I work with start at 5 AM and some leave at 5 PM. It would be great if the reminders will be sent when they walk in and/or an hour before they walk out of the office. Thanks
-
Project sheet start/finish dates
Hi all, Pretty much all my projects work over weekends. I am trying to set deadlines for start or finishes that land on either a Saturday or a Sunday, however, the project template keeps defaulting the dates back to the Friday. Any suggestions? Cheers
-
Linking Harvest hours to Smarsheet
Our company employees log all of their hours into Harvest. I see that you can send SmartSheet hours to Harvest, but I would like to pull hours from Harvest directly into my Smartsheets. Is that possible? Thank you!
-
Feature Request: Reminders with a custom days before/after or more day options
I am interested in setting up a reminder for rows where the 'Target Date' column is 30 days away. I'm only able to set reminders 14 days before a date, but it would be really helpful to send reminders at least a month out for more long-term projects.
-
Filtering Alerts
We use a sheet to keep track of documents in the review process. Is there a way to set a filtered alert so someone identified as a document reviewer gets notified when they have been added as a reviewer? Would also like to know ifthere is a way to filter an alert so that a user who uploaded a document for review only gets…
-
Hyperlinking Images?
Hello- I am working on converting an inventory spreadsheet that is currently in excel and moving it over to Smartsheet for additional functionality. I would like to include images - is it possible to actually hyperlink an image once it is attached? Thank you!
-
Dependencies and Predecessors
I am brand new to using Smartsheets and need help on creating multiple date dependencies. I want to track a myriad of tasks over time, ultimately based on a final event date. Each task has a different due date in realtionship to the final event date, and would thus have a different start date. The tracking document also…
-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
How to set calendar view permanently for a report
Hi, How can I set the calendar view permanently as a view for a report? And is it possible to display more on the calendar above the primary column?