Formula Assistance
Hi All
A newbie to Smartsheets, so please bear with me.
I have a formula that works on excel but not on Smartsheets….any ideas why?
Excel: =IF(K44="Approved",SUM(F43C44),IF(K44="Declined",F43))
Smartsheets: =if([Approver approval]43="Approved",sum([Days Remaining]42[Annual Leave]43,if([Approver approval]43="Declined",[Days Remaining42)))
Thanks Kim
Comments

Your Formula:
=if([Approver approval]43="Approved",sum([Days Remaining]42[Annual Leave]43,if([Approver approval]43="Declined",[Days Remaining42)))
your sum is not the correct reference. it is currently
sum([Days Remaining]42[Annual Leave]43
it should be
sum([Days Remaining]42:[Annual Leave]43)
you have a minus instead of a colon and don't close out the sum. your end formula should be:
=if([Approver approval]43="Approved",sum([Days Remaining]42:[Annual Leave]43),if([Approver approval]43="Declined",[Days Remaining]42
*You also incorrectly referenced the days remaining 42 at the very end of your code. you missed your hard bracket.

Got cloudflared on the edit. Anyways I took a look back at your picture you posted and I made a mistake on the sum. you don't need the sum formula, that is for a range, you just want to add two cells together then just add them.
=if([Approver approval]43="Approved",[Days Remaining]42+[Annual Leave]43,if([Approver approval]43="Declined",[Days Remaining]42

Help Article Resources
Categories
Check out the Formula Handbook template!