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
Help with a formula
Greetings, First time posting because I'm not well versed with formulas and I'm hoping that someone smarter than me can offer some guidance. I would like to create a form that assigns a point value to specific activities (e.g. JTA, IDW, SS, TR and so on) identified in different columns and sums the total value of all…
Sights Dashboards - gantt chart reports are formatting weirdly
Ok I don't know what other term to use...but on every dashboard the gantt chart reports have all reformatted themselves to make whatever column in the middle of the report HUGE...and shrinking the gantt chart part to a very small and kind of dumb looking last column. I love you Smartsheets --but you are making it almost…
Backup fails with error "SSLPeerUnverifiedException"
I'm running backups daily on the smartsheet using the java backup utility. For the last month or something the backups fails. This is the error I Using properties file: C:\smartsheet\smartsheet-backup.properties ***ERROR*** SSLPeerUnverifiedException - peer not authenticated javax.net.ssl.SSLPeerUnverifiedException: peer…
How to show date and an amount in same column
This may be an easy one or maybe not be able to be performed. I have a column that is showing the current total for the project . is there any way of showing the date in the cell as well as the amount in the same cell? or would i just need to add another column next to this one to input the date and change it when i change…
SUMIF - Circular Reference?
Hello all! I'm pretty sure I saw this functionality in one of my Engage sessions, so I'm crossing my fingers that there's a simple fix! I'd like to create a form that would allow individuals to submit project-related expenses for approval. I envision having a list of project numbers at the top of the sheet (see image, with…
Task duration
Is it possible to default task duration to hours instead of days. an example, when you enter 5, it reflects that as 5 hours and not 5 days
Change color of task rollup bar
For groups of tasks, the overall heading bar for the group is always gray. I'd like to change it's color to signify status (red, green, yellow). Is this possible.
IF(AND Today() with color
Hi Team, I've attached my If(AND(TODAY formula with color. I then set the conditional formatting to look at the row that returned "Red" or "Yellow" in this case. The question I wanted to ask, Can I avoid the conditional formatting and have the code return the color instead ? See attachment Thank You
Smartsheet slow response
Hi, I would like to know if you are also experiencing that Smartsheet is slow today (Sept. 21, 2017 - GMT+8) Thanks
Need a workaround so Parent Rows stay children rows when sorting
As I understand it, Smart sheet does not have the function to keep parent rows with children on reports like on the filter function. Which baffles me! Is there a work around that anyone can recommend for our situation? We currently have a Ready@Spike Date column. This will indicate when each child row will be completed.…