Formula HELP!

caitlin106771

Hi!

I am looking for a way to make my report of action items look better. I want to add a column that automatically can make my report look like the screenshot (attached). Does anyone know a formula that could help me? 

 

Thanks in advance!

Andrée Starå

Hi Caitlin,

You can use the symbols column for this.

More info: https://help.smartsheet.com/articles/2480316-available-symbols-in-symbols-column

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

caitlin106771

Unfortunately, that doesn't work to sort it like the screenshot above. 

 

Andrée Starå

Yes, now I get it!

It's possible with a thorough structure of the sheets. Do you have something created already?

caitlin106771

I have pulled a report and used conditional formating to show the different time periods like "past due, today, tomorrow, next week" but it still looks cramped and hard to read. See the screenshot below.

Andrée Starå

Can you maybe share the sheet(s) or some more screenshots of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Andrée Starå

Glad we got it working!

Have a fantastic weekend!

Best,

Andrée

Andrée Starå

@caitlin106771

✅Did this post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!