Fill in Date Columns with Letter to represent a Hotel

Kelsie Cohen

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!

Andrée Starå

Hi @Kelsie Cohen

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!