# Fill in Date Columns with Letter to represent a Hotel

Hey!

I am working to convert a google doc and its formulas to smartsheet. Essentially, I am using smartsheet as a rooming list that lists people, their hotel, and their check-in and out dates. There is a column for every date so we can add up the totals of everyone at each hotel on a given night.

What I am hoping to do is use potentially an IF AND formulas to put the first letter of the Hotel in the corresponding date column based on the check in and out dates.

Example: Westin 01/05/22 01/11/22 are the columns and in the column "Wed 1/5", I want a "W" to be returned in that cell.

=IF(AND([Wed 1/5]>=[Check-In]@row, [Wed 1/5]<[Check-Out]@row), true, LEFT(Hotel@row, 1))

Let me know if anyone has any ideas on what I am missing or on how to improve this formula! Thanks!

• ✭✭✭✭✭✭

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!