Newbie Question - simple formula help

AcDavi ✭✭
edited 12/29/23 in Formulas and Functions

Hi all - I'm trying to create a formula to automatically divide a $amount by 4 IF the accrual column is listed as "all 2024".

OR a more complicated formula: ideally id like to cross reference sheets to SUM all $amounts for Accrual: Q1 AND Accrual "All 2024/divided by 4" . Is it possible to do this?

total $ requested for Q1 = Any "Q1" requests AND any "All 2024"/4(to break amount into quarters) requests

Any help would be GREAT!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!