IF formula with a calculation
I am new to smartsheet and I want to combine an IF statement with a calculation. I have instruments that I bill differently. So I want to say if the instrument is the Confocal Scope then multiply the number of hours entered by 15. If it is a laser scope, it multiply the number of hours by 30. So I got a part of a formula =IF([Instrument or Service]1 = "MSC Andor Confocal", THEN =Hours@row * 15) but I am not sure how to add that function for multiplying the hours and apply it to the whole new column called Billable Time. What I have is wrong. I also dont know if I need separate billable time columns for the instruments where I charge 15/hr vs 30/hr. I managed to do a workflow for a fixed billing price because what I told it to do is : if a person was using a certain instrument to put in 100 in the billable time column. But I cant seem to do workflow for these other formulas. Thank you!
Help Article Resources
Check out the Formula Handbook template!