nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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!

Screen Shot 2019-10-25 at 11.27.00 AM.png

Find more posts tagged with

Formulas

Conditional Formatting

Comments

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.

Screen Shot 2019-10-25 at 2.31.29 PM.png

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Form adding rows to smartsheet
I have a form adding new rows to my smartsheet but it doesnt add the next number in the primary key, is there a way to do this?
Help with Cross sheet Date Value not being treated as a Date
On my sheet, I have a Planned Migration Date column that has discrete date values for each row. I have another column called "Migration Week Monday" where it determines Monday's date for the associated Planned Migration Date. My formula works well on the sheet up until I use a cross sheet formula to pull in the date value,…
Index Match Returning No Match?
Hello all. I've searched for a solution but have not found one. I am using an index match formula to return an "employee name" based on a "project name" match. The formula returns no match…but there should be. Scenario: I have a sheet which lists projects including: project #, project name, super, etc. I used a formula on…