Тёмный

Smartsheet Conditional Formatting - All You Need To Know! 

Proper Project Management
Подписаться 33 тыс.
Просмотров 13 тыс.
50% 1

Wondering what Smartsheet Conditional Formatting is and how to set it up and use it optimally? This smartsheet conditional formatting tutorial will show you all you need to know to be able to effectively do so.
👇 HOW I CAN HELP YOU 👇
--------------------------------------------
🚀 Become a Smartsheet Power User:
properprojectm...

Опубликовано:

 

21 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 20   
@bertonnawi5868
@bertonnawi5868 3 года назад
Many Thanksss ^^
@ProperProjectManagement
@ProperProjectManagement 2 года назад
Thanks Berton!
@carebeary111
@carebeary111 4 месяца назад
I am setting up a matrix that needs the same conditional formatting across many columns with different conditions. Is there a way to do this broadly? Or do I have to set up a different rule for each column for each condition?
@ProperProjectManagement
@ProperProjectManagement 3 месяца назад
I'd recommending duplicating and adjusting each one accordingly from the 'template'
@thierryfernando6569
@thierryfernando6569 2 года назад
awesomeee
@ProperProjectManagement
@ProperProjectManagement 2 года назад
Thanks Thierry. Pleased this video was useful for you!
@VowNix
@VowNix 7 месяцев назад
Can we save all these rules and copy them to another sheet? I have many sheets that are laid out the same with different data sets that need the same conditional formatting rules applied.
@ProperProjectManagement
@ProperProjectManagement 7 месяцев назад
You could make a copy of the sheet and rename/rework that copy. That would retain all of the conditional formatting by default.
@UrielVargas-h5s
@UrielVargas-h5s 8 месяцев назад
How to apply it the conditional formatting on the calendar view?
@ProperProjectManagement
@ProperProjectManagement 8 месяцев назад
Not sure it's possible I'm afraid...
@hannahhall1374
@hannahhall1374 2 года назад
Is it possible to setup formatting so that a row can automatically become a "child" row if it meets certain criteria?
@ProperProjectManagement
@ProperProjectManagement 2 года назад
Hello Hannah. I don't believe this is currently possible. Although (as a workaround), you could set up formatting to certain rows if criteria is met. Sorry if that's too obvious!
@carolynoca1481
@carolynoca1481 4 месяца назад
I believe you can do this with "indent"
@bertonnawi5868
@bertonnawi5868 3 года назад
Hii.. i would like to see on how to Show the Latest Data Only. Many time i open reports.. the data is not configured well. Please advice about the Settings maybe the Recommended Filters for the Data to be shown Only the Latest Data
@ProperProjectManagement
@ProperProjectManagement 2 года назад
Hello Berton, I would set up a new "system column" on your sheet for "date modified". I would then filter this "Date Modified" column on latest first. Hope that helps!
@longmatey80
@longmatey80 2 года назад
@@ProperProjectManagement No, set up a report - it's way easier. Add the sheet you want to pull the report on with all the columns you need, then hit sort and go to town.
@benjamingreer1660
@benjamingreer1660 11 месяцев назад
How about duplicates only. If I've got 300 numbers and need to know if I'm entering the same info again how do I have that automatically highlight.
@ProperProjectManagement
@ProperProjectManagement 11 месяцев назад
Hello Ben. Have you seen this? community.smartsheet.com/discussion/88837/identifying-duplicate-values-through-conditional-formatting
@willie265
@willie265 8 месяцев назад
Talking way to fast
@ProperProjectManagement
@ProperProjectManagement 8 месяцев назад
Hi Willie. Sorry about that; I just get a bit enthusiastic. Will take this feedback on board. Could you put playback speed to 0.75/0.5?
Далее
Best 12 Smartsheet Formulas You Need To Know & Use
16:50
How To Create A Project Plan In Smartsheet
28:34
Просмотров 102 тыс.
How To Do A Vlookup In Smartsheet - Step by Step
11:38
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
What Is Smartsheet Used For? And How Can You Use It?
13:51
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн