Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for September 2017
Discussion List
Renewal Date
Hello - I have a column for Purchased Date and a column for Renewal Date. I want the Renewal Date to automatically populate to the following year so we know when renewal is due. What is the best formula? Thanks, Barb
Office Timeline type of app for Mac
Could someone recommend mac version of Offie Timeline? Since Reporting doesn't support milestones on schedule bars (and make it one bar/row), I wanted to use Office Timeline. The catch is they don't have mac version! Thanks much!
Activity Log - Share Message Outbox
Much like an email 'Sent' folder, is there a way to view in the Activity Log of a sheet the message that was originally sent with the invitation to view/edit to a collaborator/group of collaborators?
Messaging
Is there a way to message all the people I have as collaborators? I use this product for construction management and I would like the ability to send a message to all to if we've had a major update on the schedule.
Calendar App Ad-On - PDF Generator
Hi, I'm using the calendar app add on to visualize some data. In the calendar view I have filters that when applied change what I'm seeing on the calendar as it should. When I then generate a pdf of that view I get a pdf that displays all data including what I had filtered out in the app. How do I generate a PDF that…
Locking columns but allowing form submissions, comments and attachments
Hi, I have a sheet I'd like to share with others, but not have them be able to directly edit the info in the columns. Instead, I'd like them to use the comments as well as use a form to submit requests. The form fields would correspond to the columns in the sheet and their submissions would appear at the bottom of the…
Track the number of days each task has been delayed
I am trying to track the number of days each task on my project plan has been delayed, I found a formula on https://www.smartsheet.com/blog/smartsheet-tips-tracking-baseline-schedule-variance But the formula is counting weekend days (I already set work days to Mon-Fri). Any suggestions? Thanks,
Completing sub tasks
Quick question...if I mark or move all sub tasks related to one parent card as 'Complete', why does the parent card not automatically roll up to 'Complete'? Thanks.
Comments
I find the comments with date/time stamp to be very useful. What would be a nice enhancement would be if you could hover over a comment to see one or more recent entries.
RYG balls automation
Hi, I went thru existing discussion but could not find my exact need. I would like to automate the RYG balls to change color based on two dates columns. For exemple if "date issued" is blank I need a yellow ball, if "date issued is not blank but "date released" is still empty then show a red ball and finally if both date…