Welcome!

IF formulas

Hi,

Tried looking for my question hoping it was already answered, loving how Smartsheet community works.

I'm new to Smartsheet and need help with an IF formula.

My company has several titles (positions). In the Title column there is a drop down menu for 5 Titles. In another column, I have their Rounded Hours for per line.

I have created three separate columns that will eventually subtotal hours per Title.

So, if Title $1, enter the Rounded Hours for that line. if Title $2, enter the Rounded Hours for that line (we are temporarily combining Title $1 and Title $2). If Title $3 $4 or $5, enter 0 for that line.

This is what I tried.

=IF(Title8=Title$1,[Hours-Rounded]8, IF(Title8=Title$2,[Hours-Rounded]8, IF(Title8=Title$3,"0", IF(Title8=Title$4,"0" IF(Title8=Title$5,"0")))))

Thanks so much!

Danielle

Find more posts tagged with

Comments

Shaine Greenwood

Hi Danielle,

Try removing the quotes around your numbers. Only text strings should have quotes around them in Smartsheet formulas.

There's also a missing comma between your second-to-last and last IF statements:

=IF(Title8=Title$1,[Hours-Rounded]8, IF(Title8=Title$2,[Hours-Rounded]8, IF(Title8=Title$3,0, IF(Title8=Title$4,0, IF(Title8=Title$5,0)))))

Sign in to join the conversation!

Quick Links

Trending discussions

Automation Not Working
I have a sheet set to notify myself and another user when ANY CHANGE is made to the sheet. Neither of us received the notification. Any suggestions on why this is not working? It has been a while since this form was used, but it worked previously.
Why am I not getting reminders?
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
Membership/ Access question
Hi Everyone, My IT has a lot of confusion on what we access we really need to have for certain people. What is the difference between a "Member" and a "Licensed User?" We have a lot of sheets that have owners who do all of the changes of the sheet. I know that they need to be licensed users. But then, we have a lot of…