What a simple way to explain the IF formula! Great video! I'm trying to replicate it with a contact list column as a reference, but looks like this type of data is not a valid data type. :(
Hi, I'd appreciate your help, I'm trying to build a column with an IF function in SmartSheet, which will include a percentage calculation inside, a percentage that I will set in advance 0, 50,100 There are projects in progress, the column should rely on 3 things Not started=0 In progress = 50 Complete = 100 I can't manage to arrange the formula in the spreadsheet, it keeps showing me an error message
Like the video, but have not been able to apply it in my situation. I have a column labeled Status. It is populated by dropdown values: Not Started, In Progress, Complete, Canceled, On Hold. When I try to populate another column based on those values using this formula >>=IF(Status@row = "Complete", "100", "0",)
![BOWKYLION - วิงวอน (ex-change) [Official MV]](http://i.ytimg.com/vi/cLdnZWDaO-w/mqdefault.jpg)
Get my Smartsheet Formula Training course: properprojectmanagementtraining.teachable.com/p/smartsheet-formula-training-course
Thank you. Video was useful.
You're welcome!
What a simple way to explain the IF formula! Great video! I'm trying to replicate it with a contact list column as a reference, but looks like this type of data is not a valid data type. :(
Glad it was helpful! Thanks for your comment.
Hi, I'd appreciate your help, I'm trying to build a column with an IF function in SmartSheet, which will include a percentage calculation inside, a percentage that I will set in advance 0, 50,100
There are projects in progress, the column should rely on 3 things
Not started=0
In progress = 50
Complete = 100
I can't manage to arrange the formula in the spreadsheet, it keeps showing me an error message
Id suggest checking this out: help.smartsheet.com/function/if
Like the video, but have not been able to apply it in my situation. I have a column labeled Status. It is populated by dropdown values: Not Started, In Progress, Complete, Canceled, On Hold. When I try to populate another column based on those values using this formula >>=IF(Status@row = "Complete", "100", "0",)
You could use something like >> =IF([Status]@row = "Completed", 1, IF([Status]@row = "In Progress", 0.5, IF([Status]@row = "Not Started", 0, IF([Status]@row = "On Hold", "ON HOLD"))))
I would like a way to move data from an active sheet to an achieve sheet when the project is completed.
Have you checked out this video: th-cam.com/video/wFJikpyTce4/w-d-xo.html&pp=ygUcaG93IHRvIGFyY2hpdmUgaW4gc21hcnRzaGVldA%3D%3D
thanks Mr
You're welcome Ikwan!
good
Thanks for the comment and kind words!
Não poder utilizar Símbolos em conjunto com as fórmulas é horrível.
não é ideal