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
Return a date value that is the 1st day of the month, depending on what month we are in today.
I need to create a formula that if a checkbox column is blank, then a date is entered into a Start Date column which is the first of the month of todays month date. The checkbox column is checking if the row was created in 'This month'. So if a row was created on 3rd April 2016 for example 3/4/2016, the checkbox would be…
Sum rows that are not children
I am creating a SS that contains a row for each event and below children for event expenses. The top/parent row calculates the sum of the children beneath it. I would like to create a Totals row that calculates the sum of all the top/parent rows. Is this something SS does?
Hey new member here, are you guys planning to have an API to add graphs to sheets and sights? I've read a few posts on the topic already, is this in the works? Any ETA on that?
Modify Calendar View?
I'm trying to take a list of dates and associated activities - potentially up to 15 per day -- and display them in a calendar format...either traditional or agenda layout. I have curriculum maps -- material we will cover each day for 6-8 weeks - listed out in spreadsheet format and then want to turn that into something…
Automating RYG And CHILDREN Formula
Hi I am looking for a formula that will show in the parent an RYG colour based on the children. If there are any Red in the children, I want to show Red in the parent, If there are no Red but there are Yellow in the children, Show Yellow in the parent. If there are no Red or Yellow but there is Green in the children, Show…
reminder for update requests
Hi there, is there a way to remind users to update requests if they haven't done it. Thks Peter
At the risk of stealing Smartsheet's thunder, I would like to personally thank Travis Hannon for all the great answers, insightful comments, and general enthusiasm to help the Community (and me) with all problems great and small. I'm sure he'll pop up occassionally as his new role as a Smartsheet Consultant allows and…
Expand column width
Hi, Refer to below image, there are few collapsed columns - I'm not able to open them by draging the edge of the column, any tips how to expand them? thanks.
How do you export a Gantt chart to Excel ?
I am unable to export the Gantt chart to excel. Only the values and data is being exported but not the chart itself.
Hi, it would be helpful to have a duplicate row kew. This would speed up data entry very much when using similar content of a row, e.g. preparing, holding, follow up a meeting/presentation as three rows. Kind regards Michael