# INDEX MATCH AND formula assistance

Overachievers Alumni

I currently have a formula to determine the day of the week when a date is selected, which works perfectly.

=IF(WEEKDAY([Overtime Date]@row) = 1; "Sunday"; IF(WEEKDAY([Overtime Date]@row) = 2; "Monday"; IF(WEEKDAY([Overtime Date]@row) = 3; "Tuesday"; IF(WEEKDAY([Overtime Date]@row) = 4; "Wednesday"; IF(WEEKDAY([Overtime Date]@row) = 5; "Thursday"; IF(WEEKDAY([Overtime Date]@row) = 6; "Friday"; IF(WEEKDAY([Overtime Date]@row) = 7; "Saturday")))))))

I have added a checkbox which should be selected if the day is a public holiday.

The index match references the table below to determine the amount it should be multiplied by.

I need to change the formula to include that if the Public Holiday box is selected, the amount to multiply by should be 2,0.

I do not know if the INDEX MATCH is the correct formula for this, or whether I should rather be using a VLOOKUP IF formula.

Any assistance will be appreciated.

M

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Michelle Basson

Smartsheet Overachiever Alumni | Solution Consultant | Lover of everything Smartsheet

CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk

• Overachievers Alumni

I am very well, thanks. Hope you are doing great.

This is so ovbious 🤦🏼‍♀️

Must be the late nights breaking my brain. Thanks for the spot on response. Really appreciate.

Have a great day.

M

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Michelle Basson

Smartsheet Overachiever Alumni | Solution Consultant | Lover of everything Smartsheet

CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk

• ✭✭✭✭✭✭

I hope you're well and safe!

If I understand you correctly, you should only need to add an IF function to check if the Public Holiday checkbox is checked, then it should show 2, or if it isn't, run the INDEX/MATCH formula.

Would that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Overachievers Alumni

I am very well, thanks. Hope you are doing great.

This is so ovbious 🤦🏼‍♀️

Must be the late nights breaking my brain. Thanks for the spot on response. Really appreciate.

Have a great day.

M

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Michelle Basson

Smartsheet Overachiever Alumni | Solution Consultant | Lover of everything Smartsheet

CERTIFIED SMARTSHEET PLATINUM PARTNER
www.projectplanservices.co.uk

• ✭✭✭✭✭✭

Excellent!

Glad to hear you're well, and I am too!

Easy to miss!

Happy to help!

Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!