-
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?
-
Sorting Numbers with a "-" in it
Hi all, Probably my incompetence here but i have a confusing issue at the minute. I have a long list of job numbers and am trying to sort them in numerical order. There is a criteria that we use to create these that you should probably be aware of: * Primary number is a 5 digit numerical number (i.e.21495) * If there is…
-
Countif children row with reference another sheet
I want to count the children rows in another sheet that contain a certain value, my attempt gets an #UNPARSEABLE =COUNTIF(CHILDREN(){Lease Tracker 2018 Manager},="CORNELIUS")) Any thoughts? THANKS!
-
Alterar o modo de visualização da planilha individualmente
Olá, foi o possível substituto do modo de exibição da planilha doce? a Planilha é compartilhada, mas todo usuário tem sua função e visualiza o conteúdo de forma, porém, cada mudança, por exemplo, no tamanho da barra, altera para todos os usuários, sendo que essa alteração é tão séria necessário para um único usuário.
-
If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…