Calendar Help

richard_abra

Hi all,

How can pull data from 1 cell to a calendar on another sheet on a date selected from another cell.

To try and explain, see below. i want the job info to go to the calendar sheet on the job date day.

hope this makes sense!

Paul Newcome

Yes. That goes into the schedule and references the source sheet. I did have a very slight typo. It should have bene corrected when you were creating your cross sheet references, but just in case...

=IFERROR(INDEX({Source Sheet Job Info Column}, MATCH(Date@row, {Source Sheet Date Column}, 0)), "")

Paul Newcome

You would use something along the lines of

=IFERROR(INDEX({Source Sheet Job Info Column}, MATCH(Date@row, [Source Sheet Date Column}, 0)), "")

richard_abra

https://community.smartsheet.com/discussion/comment/418114#Comment_418114

Thanks Paul, so this goes in the column in the scheduele? then i select the columns from the source sheet. Not working atm but will keep trying.

Paul Newcome

Yes. That goes into the schedule and references the source sheet. I did have a very slight typo. It should have bene corrected when you were creating your cross sheet references, but just in case...

=IFERROR(INDEX({Source Sheet Job Info Column}, MATCH(Date@row, {Source Sheet Date Column}, 0)), "")

richard_abra

https://community.smartsheet.com/discussion/comment/418342#Comment_418342

i that case i must be referencing wrong... how should it be?

Paul Newcome

It should be how I have it in my example. Each {Cross Sheet Reference} indicates the sheet and column it should be referencing.

richard_abra

https://community.smartsheet.com/discussion/comment/418704#Comment_418704

it works!!! thanks so much!

Paul Newcome

Happy to help. 👍️