formula if then - output number of days

WinaHath
WinaHath ✭✭✭✭
edited 12/07/23 in Formulas and Functions


If Written Notice Due (Days) = 30, then Advance Notification days = 90; if 60 then 120, if 90 then 150, if 120 then 240

I will enter the data on Written Notice Due Days column (30/60/90/120) and I need a formula to output to Advance Notifications.



Best Answer

  • markkrebs
    markkrebs ✭✭✭✭✭✭
    Answer ✓

    =IF([Written Notice Due (Days)]@row = 30, 90, IF([Written Notice Due (Days)]@row = 60, 120, IF([Written Notice Due (Days)]@row = 90, 150, IF([Written Notice Due (Days)]@row = 120, 240))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!