-
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…
-
Conditional Formatting - Cell
Hello, How can I get conditional formatting to apply to a cell that matches a value in a column? It only lets me highlight an entire row or column, not just the individual matching cell.
-
External URL
How can I make a link to an external url so people can click on the link and it takes them to open up a webpage?
-
Sign up form conditions
I am creating a sign up form with dates, but how can I set up conditions where if one date is taken then it alerts someone to select another date?
-
Conditional Formatting one row at a time
Hello, when I set up conditional formatting on a sheet it applies to the entire sheet. I would like to set a different criteria for each row and when the conditions are met, I would like that row to turn red. How can this be achieved?
-
Notifications including comments
Hello, I am needing the notification that gets sent from a SmartSheet to show the body of the comments. Currently it only shows the comment symbol as below. The other formatting change i would like is to run the row vertical rather than horizontal. Thanks!