-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Next deliverable date
I have a list of deliverable dates and I would like to make the next deliverable date turn red, all dates after that remain white and any dates that occur in the past green. I figured out how to get all past dates green but I can't figure out how to turn only the next date in the future to turn red without turning all the…
-
Merge Add-on for Google: Formatting Options?
I'm using the Merge Add-on to generate email messages and PDF documents from my Smartsheet. While my sheet has many columns of dates in the MM/DD/YY format (which is good for managing the data), I'd like my documents to be in the 'monthname dd, yyyy' format. Are there formatting codes for the merge fields, or is there…
-
Help needed with formulas - paid work opportunity!
Hi everyone, My colleague and I are new to SmartSheet and we are having some issues with a few formulas and we can't quite work out what has happened. We are offering paid work at an hourly rate for someone to join our team to help troubleshoot and fix our SmartSheets issues. If you're interested, please let me know!…
-
Hide rows when a task is completed.
Hello! Smart sheet is a good tool for keeping upto date with daily tasks. However as the days go by the rows increase and they are not in the normal view and we have to scroll down to go to the tasks. Is there a way that the rows will automatically hide after a few days of completion or once the task is completed. Thanks…
-
Conditional Formatting
I was wondering if there is a way to apply conditional formatting on a cell based on the outcome of another cell. For instance, I have a % Complete Calculated column and a % Complete Actual column. Is there a way to change a cell in the % Complete Actual column yellow if it is less than the % Complete Calculated?
-
Feature Request: Ability to @ someone and they get notified
I would love the ability to be able to @ someone when making a comment, and then they get notified in and email that I mentioned them. This would really help when I am making comments and I want people in my team to see that comment (without having to use the notifications feature because it isn't that great because it is…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Presetting Project Start and End date - Missing in Smartsheet
In Microsoft Project, you can set a project schedule's start and end date and that sets the date range for a project schedule. I can't see that feature in smartsheet. This would be nice since a lot of us use templates in our PMOs that we'd like the ability to do this everytime we start up a schedule so the dates pre-fill…
-
Applying Existing Conditional Formatting from one sheet to another
Is there anyway to copy conditional formatting created into one sheet to another when the other sheet already exists with data without manually recreating?
