if formulas, and adding status symbol (Empty, Quarter, Half, Three Quarter, Full )

Tara Knox

Good morning!

I need some help with these Smartsheet Formulas. I don't even know if it is possible, but I am trying to get a formula written that captures the status of column "Complete Date". As people fill in the date they completed their task, it will translate the status symbol to the appropriate amount.

I am just learning Smartsheet so any help would be great! Thank you!

Tara

Paul Newcome

Can you provide the exact logic similar to...

If [Column name]# = specific criteria, output this.

If [Column name]# = this other criteria, output this.

so on and so forth until all possibilities are covered?