Display 2 dates in one sheet summary field

AmandaB23

can I display both a start date column and end date column value in ONE sheet summary field

IE

start date column in sheet 11/7

end date column in sheet11/14

Sheet Summary field 11/7-11/14

Help please :)

Andrée Starå

Hi @AmandaB23

I hope you're well and safe!

Try something like this.

=[Start Date]1 + " - " + [End Date]1

Did that work/help?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @AmandaB23

I hope you're well and safe!

Try something like this.

=[Start Date]1 + " - " + [End Date]1

Did that work/help?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

AmandaB23

@Andrée Starå this was very helpful, do you know how I can do the same thing and remove the time?

When I do this Im getting a time as well as date

1/16 8:00 AM - 2/27 2:59 PM

and I just want the date range

Andrée Starå

@AmandaB23

Excellent!

You're more than welcome!

Try something like this. (adjust the number of characters to match what you need)

=LEFT([Start Date]@row, 5) + " - " + LEFT([End Date]@row, 5)

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

AmandaB23

@Andrée Starå that is returning an error , I realized its because dependencies are enabled.

When I turn that off , it works. When I turn it on - which I need it on for date and % rollup , it adds the time.

=LEFT([Start Date]@row, 5) + " - " + LEFT([End Date]@row, 5)

Seems to not include designating which row - am I missing how to combine the two queries (to pull both dates + limit character length?

Andrée Starå

@AmandaB23

I added @row, so you don't have to think of row numbers but try this one instead.

=LEFT([Start Date]1, 5) + " - " + LEFT([End Date]1, 5)

Did that make any difference?

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

AmandaB23

@Andrée Starå It is 7pm here , I am in manic mode trying to redo my entire portfolio plan for a large client.

YOU ARE A LIFE SAVER.

I can not say thank you enough!!

Andrée Starå

@AmandaB23

Thanks for the kind words!

I'm always happy to help!