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!
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.
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.
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!
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.
Get my Smartsheet Formula training course: properprojectmanagementtraining.teachable.com/p/smartsheet-formula-training-course
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!
Hi Natye. Thank you for letting me know and I'm really sorry about that. Perhaps something to do with the upload. Sorry again.
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.
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.
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!
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.
Thanks Sir.
Most welcome
Where do you find the Function sheet in Smartsheet?
help.smartsheet.com/functions
Thank you
You're welcome!
Can you audit predecessors and successors of SS formulas?
Hello Stephan. Great question. This resource may be of help: community.smartsheet.com/discussion/84257/successors-testing
I WANT COFFEE!!!!!!!
Coffee fuels PPM!
Your screen is very small, Can not see properly.
Thanks for the feedback. Have you tried expanding the screen with the out player? Does that help?
I WANT COFFEE!!!!!!!
I always want coffee!