-
Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
-
Formula for when if a checkbox is checked...or not
What would be the formula that would return "True" if a checkbox is marcked as checked and "False" if it is not? Thank you!
-
Gantt scheduling of holidays
If holidays are entered in the "Non-Working Days", will there be visible evidence in the Gantt chart to reflect this?
-
Make Collapse ALL default
I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.
-
Row Height
Is there a way to shrink row height, even if the font size does not want to allow? This is possible in MS Excel, even if lower parts of letters (like y, g, etc) are slightly cut off.
-
Feature Request: JOIN() carriage return separator
I would like to JOIN() to allow the carriage return as a separator. This would allow me to transpose the data. JOIN([Column1]23:[Column12]23,"\n") would take the row and give me a cell with the contents transposed vertically. JOIN([Column1]1:[Column1]22," ") would take the column and give me a cell with the contents…
-
Freeze row or rows at top of sheet or column info mouse-over
Since the column header are fairly limited in max length, it would be nice to be able to add some info on the column purpose to either a row that has been frozen (does not scroll with rest of sheet), or to a mouse over field. Is there any plans for such a feature. Kind of surprised it isn't already in place. Maybe I am…
-
Formula to determine row number
Hello, I am wondering if there is a way to determine the row number of a specific row. I know this can be done in Excel with the row() function. This does not work in Smartsheet. The reason I am looking for it is because I have a formula that needs to apply to every row that checks the row above it, but that fails when it…
-
Report Developing - Removing "Header" task
Hello all, I am trying to see if there is a way to remove those "header" tasks from reports. I ask this because it captures dates from the sub tasks and therefore becomes duplicative in a report. I have colored these lines so its easy to overlook them now but it would be lovely to have a way to remove them completely. For…
-
How to use end date and percentage complete to automate RYG status
Hi everyone, Maybe my brain is struggling with IF and AND statements, but this is defeating me. I am trying to use the end date of a task compared to today's date and the percentage complete (great than or equal to 75%) to drive my status column of red, yellow, green balls. I think I need to find a way to combine the…
