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


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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!