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(F43-C44),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

Find more posts tagged with

Formulas

Comments

L_123

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.

L_123

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

Reklaw

L@123

Thank you so much. Worked a treat

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?