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.
Discussion List
Do row comments expire?
One of my team mates can't seem to find older comments she's put in the comments section. Do they expire after a certain amount of time?
Webform
I am using bubbles on my webform, but if someone changes their mind and wants to not check the bubbles, how do they do that? (it is not required). With the dropdown they can just go back and use the blank - but in the bubble format they don't have a way to UN--CHECK the bubble. HELP! Kawehi
Nesting if functions for blank cells
I'm trying to create a formula with the RYB balls that says if two date columns (Start and Completed) are blank, then the value should be a red ball. If there is a date in the start column but not in the completed column, then the value should be a yellow ball. If both columns have date, then the value should be a green…
Computing duration from a min and max column
I'd like to support a Min Duration and Max Duration, and then compute Duration as an average of the those two and be reflected in the Gantt Chart. Is it possible?
SUM between Sheet 1 & 2 for Time range
Hi everyone, I'm stuck and need a little help. I'm trying to group Time ranges either both columns "A & B" if doable, or just column "A" into multiple 3-Hours bucket for the day with =FLOOR or similar and pick the highest number of Customers from same bucket/ time window of 3-hours with =LARGE from Sheet 1 & Sheet 2 then…
IF(AND Please help
=IF(AND(Status2 = " WON", [Probability Hit Rate]2, 1, [Value Of Jobs]2))
Reports Not Functioning
Is anyone else have problems with reports not functioning properly? The data from my master files and not pulling into the report as it normally did in the past. I confirmed all criteria and nothing has changed.
Project Build
Hello all, watching the newly published video https://www.youtube.com/watch?time_continue=66&v=WtIcIkMnsrk at the 1:00 mark they are using a project build tool. is this an enterprise feature? I cant find it Stuart
Conditional Formatting Do not modify current value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met. How do I tell SS to leave the current value as is if the condition is not met? =IF([Modified By]1 = Owner1, " ", Modified1) Background: Above…
Printing All Comments by Sheet
Hello! Is there a way to print all the comments contained in a sheet? Right now, all I can see is the option to print them row by row. Thank you, Sandy
