Best 12 Smartsheet Formulas You Need To Know & Use

[@ProperProjectManagement]

Get my Smartsheet Formula training course: properprojectmanagementtraining.teachable.com/p/smartsheet-formula-training-course

[@kzzink649]

Very helpful information. Easy to listen too. No crazy music or just clicking. He offers actual explanations for the user. I have checked out some of the other videos and they are done really well. Great Job!! Will continue to view them for other information I am looking for. I wonder if Smartsheet has a limitation to the amount of characters per cell? That is challenging information to find.

[@ProperProjectManagement]

Hello Kz thanks for the kind words about my channel. Smartsheet does have a cell limitation of a certain amount of characters. I am not sure what the precise number is as I believe this has been expanded over the years.

[@natyebriggs3387]

This was super helpful indeed. However the last 3 formulas were blurry and made it difficult to practice alongside your video. Thank you for all your help!

[@ProperProjectManagement]

Hi Natye. Thank you for letting me know and I'm really sorry about that. Perhaps something to do with the upload. Sorry again.

[@trankimkhanh4050]

Thanks Sir.

[@ProperProjectManagement]

Most welcome

[@jo-annhoye6299]

Hi there! This is super helpful...I'm working on a project that I need to get the percentages of an evaluation from a presentation that used a likert scale "1 less likely to 10 most likely" and would love to know how to master the formulas to complete this task. After reviewing your tutorial...I'm thinking that i will begin to play with COUNTIF...but i'm not really sure....could you advise? thanks!

[@ProperProjectManagement]

Hi Jo_Ann, COUNTIF sounds like a great formula to start out with and for this task. You could even extend it to a COUNTIFS if you need additional arguments to create your scale.

[@2010Gullwing]

Where do you find the Function sheet in Smartsheet?

[@ProperProjectManagement]

help.smartsheet.com/functions

[@kwoolfolk9787]

Thank you

[@ProperProjectManagement]

You're welcome!

[@stephanweaver1960]

Can you audit predecessors and successors of SS formulas?

[@ProperProjectManagement]

Hello Stephan. Great question. This resource may be of help: community.smartsheet.com/discussion/84257/successors-testing

[@leighhilt9267]

I WANT COFFEE!!!!!!!

[@ProperProjectManagement]

Coffee fuels PPM!

[@laboniqac2258]

Your screen is very small, Can not see properly.

[@ProperProjectManagement]

Thanks for the feedback. Have you tried expanding the screen with the out player? Does that help?

[@leighhilt9267]

I WANT COFFEE!!!!!!!

[@ProperProjectManagement]

I always want coffee!