Percentage formula for multiple Columns

Options

Noemi V

Noemi V ✭✭

03/14/24 in Smartsheet Basics

Hello I'm trying to set up a formula that will track the percentage completed for about 10 columns. The columns consist of dates and checkmarks .

0 ·

Answers

MariaCurtis ✭✭✭✭✭

03/16/24

Can you share some more details? Hard to help out without an example. You can blur out or create fictitious data if that helps.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Viewing Access After 30-Day Trial
My leadership would like to access one of my dashboards but I have no intention of adding them as licensed users but they need a login to open in it on their phone. I tried having one open the link in safari and it still makes them create an account. My only concern is that after the 30-days their account won't let them…
Colors will not move over from Grid view to Calendar view.
I have two conditional formats set up. They change the color of rows if a value is met. The formatting works in grid view, but only one color will move over to the calendar.
Why is conditional formatting not working on my sheet?
I have set up this conditional formatting rule to highlight a row when the Customer Name is #No Match. So far it is not working. I have tried changing it to contains instead of is and still doesn't work. What am I doing wrong? Janet

woman with hands out and open

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video<