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!
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!