Город МОСКОВСКИЙ
00:06:35

Progress Bar in Google Sheets

Аватар
Новый уровень JavaScript
Просмотры:
21
Дата загрузки:
29.11.2023 06:35
Длительность:
00:06:35
Категория:
Лайфхаки

Описание

In this how to, Lean Strategies International LLC will show you how to make a progress bar in #googlesheets using a countif formula and a sparkline formula. As a reminder google sheets is part of the google #workspace platform.

- Please #subscribe and Like the Video to support the channel Here and receive more FREE Content: https://www.youtube.com/channel/UCTo9HhaU7S1hnKxb8Munlvw?sub_confirmation=1

Want to sign up for more advanced features on google #workspace and help the channel out? Visit: https://www.leanstrategiesinternational.com/workspace.html

The Formula shown in this video is:

=sparkline(COUNTIF(C2:E2,"TRUE"),{"charttype","bar";"max",3})

** Note: you will need to select the appropriate cells where "C2:E2" is.

Рекомендуемые видео