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 2016 Posts
Archives for May 2016
Discussion List
Automatically update status icon
I would like to know if there is a way to automatically update the status icon? If I have 5 colums, first being the task, second: start date, third: complete date, fourth: target complete date and then an icon status column, is there a way to automatically have it go from either yellow or red to green once a Complete date…
How to write a formula to sum up child values into Parent row?
How can I write a formula that sums up all the effort (hrs) into the parent row for which those tasks are under?
Recurrent Reminder for anniversaries and Birthdays - old dates
Hi there, I set up a spreadsheet with all our employees' details. Now I need to set up recurrent reminders for Date of Births and Anniversaries, but obviously, being old dates they are not considered. Is there any way where this can be done? Thanks
Done Tasks
Hi, Is there anyway to hide or do away with done tasks automatically? thanks
Assigned tasks to Google Calendar
* Hi guys, * * Is there anyway to export tasks "assigned to me" across multiple sheets to google Calendar. I can build a report but reports cannot be synced with google calender. thanks
Sharing out Statistical Data
Hi everyone, What templates would you recommend for a report exclusively showing statistics? No date information will be included in this report (beyond the name of the month); however, there are three layers of statistics I need to share out by month. Any ideas? I look forward to hearing any and all suggestions- Alyssa
Auto-Sorting Completed Tasks
I've done a bit of digging around, but wondering if I'm just not digging in the right places: What I'd like to do is set a rule that when a row is marked Done/Completed/Etc.. that it moves to the bottom of the sheet. Is there a way to create that kind of sort rule?
Formulas and data
I have a fairly simple sheet used to track travel costs by subcategory and estimate/actual comparisons. I want to add new data lines into the sheet inside the subcategories and have the subcategory total formulas automatically adjust to the larger data table. When I try it the formula data range remains static, referencing…
Change resource management colors?
Is there a way in Resource Management screen to change any colors? I would like to change the color for specific blackout days and PTO so it's visibly clear that those days are off limits. Thank you
Discussions - Allow html and embedded images
I would like to see if under the discusisons section of an entry if the discussions can be updated to allow html graphics. There are times when we have to copy/paste into the discussions field and we are copying from an outlook html email. Many times users will embed images into the email and/or their signature or other…
