Looking for a formular to help with a rooming list...


I have lots of passengers on separate rows.

I have a heading row of dates.

I then have a sequence of 1's in a grid that show which nights a person will check in for 1 over night stay.

In the first example, my traveller will check in on 17/06 and check out on 24/06.

I am currently having to update the columns manually when somebody tags me in a comment to say the grid has chnaged.

I wish to have a column called check in and check out, which auto updates whenever 1's in the grid are updated... please help :)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!