Conditional Formatting - Excerpt from 101 Webinar Smartsheet English French

Conditional Formatting - Excerpt from 101 WebinarYouTube↗ IA↗(long shot)
Science & Technology 80K views 12 likes 0 dislikes 07 Jul 2014

Smartsheet 48.9K subscribers United States YouTube↗

Click to Play Video

this is an excerpt from our 101 training on conditional formatting the

Ceci est un extrait de notre formation Smartsheet 101 sur la mise en forme conditionnelle.

conditional formatting button is located

Le bouton de "Mise en forme conditionnelle" est situé dans la barre d'outils

on your toolbar and conditional formatting rules are used to

et les règles de mise en forme conditionnelle sont utilisées pour appliquer une mise en forme de fa çon automatique

automatically apply formatting to cells based on values they contain conditional

à des cellules sur des valeurs qu'elles contiennent.

formatting is used to apply formatting but not to change cell values so let's

La mise en forme conditionnelle est utilisée pour appliquer une mise en forme mais non pour modifier les valeurs des cellules.

say I want to highlight all the rows to have a read status because those are the

Donc, prétendons que je souhaite faire ressortir toutes les lignes qui sont marquées d'un statut en "rouge" parce qu'ils s'agit de tâches

paths that I need to pay more attention to so I select set condition if the

auxquelles je dois payer plus d'attention, donc je sélectionne "Ajouter une nouvelle condition" :

status is red apply this format to the

si le statut est rouge, appliquer ce format à la ligne entière.

entire row and all conditional

Toutes les règles de mise en forme conditionnelle permettent la mise à jour en tant réel

formatting rules are live updating so if I make a change in my sheet the

donc si je fais une modification dans ma feuille, la mise en forme sera

formatting will be automatically applied

automatiquement appliquée.

maybe I only want to see the items that

Mais peut-être que je ne souhaite voir que

are have a read status and are due in

les éléments qui ont un statut en rouge et sont dûs le mois prochain.

the next month so I can add an and

Donc, je peux ajouter une condition "ET",

condition say the due date is in the next 30 days and now I'm only going to

par exemple la "Date d'échéance" est dans 30 jours.

see the task highlighted where the due date is in the next 30 days you can set a conditional formatting rule for pretty

Maintenant, je verrai seulement les tâches mises en évidence dont la date d'échéance est dans 30 jours. Vous pouvez établir une règle de mise en forme conditionnelle pour chaque aspect de votre feuille.

much any aspect of your sheet if James

Si James Page se rend sur la feuille, il peut établir une règle

page comes into the sheet he can set a rule that highlights any task that is assigned to have

qui met en évidence toute tâche qui lui est assignée.

so now any task that is assigned to James will highlight the assigned to

Donc maintenant, toute tâche qui sera assignée à James fera ressortir la

colonne "Assignée à" en vert.

to learn more about smartsheet watch our full 101 training session

Pour en apprendre davantage sur Smartsheet, regardez notre formation complète "Smartsheet 101".

Similar videos:

Smartsheet 101 Tutorial
Smartsheet
259.4K views 451 likes 40 dislikes 13 Jul 201142% match

Cell Linking - Excerpt from 201 Webinar
Smartsheet
72.7K views 17 likes 4 dislikes 01 May 201440% match

Smartsheet Overview for New Collaborators
Smartsheet
78.5K views 157 likes 4 dislikes 22 Dec 201440% match

Working in Smartsheet
Smartsheet
106.7K views 64 likes 3 dislikes 04 Apr 201439% match

Smartsheet Overview for New Collaborators
Smartsheet
63.8K views 231 likes 21 dislikes 16 Oct 201238% match

Introduction to Smartsheet
Smartsheet
106.8K views 118 likes 12 dislikes 10 Apr 201837% match

Sharing in Smartsheet
Smartsheet
2.1K views 4 likes 0 dislikes 06 Apr 202036% match

Reporting in Smartsheet
Smartsheet
115.4K views 36 likes 4 dislikes 17 Aug 201535% match

Gantt Chart View
Smartsheet
120K views 28 likes 2 dislikes 07 Dec 201534% match

Smartsheet - The Best Online Spreadsheet for Managing Work
Smartsheet
486.6K views 362 likes 14 dislikes 23 Sep 201134% match

Welcome to Smartsheet Gov
Smartsheet
1.1K views 8 likes 0 dislikes 29 Jan 202034% match

Gantt Chart View
Smartsheet
44.9K views 10 likes 0 dislikes 25 Sep 201834% match

We Work in Progress | Smartsheet Careers
Smartsheet
1.5K views 15 likes 2 dislikes 17 Feb 202133% match

Smartsheet Aligned partner program
Smartsheet
986 views 3 likes 0 dislikes 24 Jan 202033% match

Gantt Chart with Dependencies
Smartsheet
42.2K views 73 likes 2 dislikes 06 Apr 202033% match

Smartsheet Template Set Overview
Smartsheet
6.7K views 14 likes 0 dislikes 08 Jul 202033% match

Project Management with Gantt Template Tutorial
Smartsheet
308.9K views 197 likes 18 dislikes 21 Oct 201333% match

How to Set Up a Sheet
Smartsheet
64.6K views 19 likes 2 dislikes 10 Apr 201832% match

Rows and Hierarchy
Smartsheet
54.6K views 5 likes 0 dislikes 26 Sep 201831% match

Getting Started with Dashboards
Smartsheet
62K views 31 likes 5 dislikes 14 Feb 201831% match

How to Set Up a Sheet
Smartsheet
125.9K views 93 likes 6 dislikes 17 Dec 201831% match

Smartsheet Sync for Google Forms
Smartsheet
70.7K views 15 likes 4 dislikes 27 Oct 201431% match

How to Set Up a Sheet
Smartsheet
121.9K views 128 likes 5 dislikes 08 Oct 201931% match

If Your Work Could Talk...
Smartsheet
443K views 107 likes 50 dislikes 19 Sep 201731% match

Smartsheet Project Management Overview
Smartsheet
64.3K views 104 likes 8 dislikes 15 Nov 201230% match

Make Better Decisions, Faster with Smartsheet Dashboards
Smartsheet
112.8K views 21 likes 7 dislikes 14 Feb 201830% match

Make a Gantt Chart with Dependencies
Smartsheet
86.5K views 30 likes 4 dislikes 07 Dec 201530% match

Automated Workflows Overview
Smartsheet
72.2K views 34 likes 2 dislikes 11 Jun 201930% match

0 views 0 likes 0 dislikes 05 Jun 202630% match

New Navigation Menu
Smartsheet
50.1K views 7 likes 4 dislikes 21 Dec 201830% match

Settings Privacy About Contact Donate