Newbie Question - simple formula help

AcDavi
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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!