Best Of

Re: Return All Values based on a Filter

https://community.smartsheet.com/discussion/comment/470931#Comment_470931

This is awesome!!

I wish Smartsheet would make a few edits like array formula flows and conditional formatting for "duplicate values".

Pestomania

1 ·

Re: Metrics not matching Dashboard

Sounds good, Georgie - Yes, I have tried the suggestion and now I'm waiting to see if it behaves the same way it was behaving the past couple of days but thank you for your help! I'll be sure to open that ticket if need be, thanks again!

Amelia P.

2 ·

Re: Metrics not matching Dashboard

Hi @Amelia P.,

Have you tried deleting and recreating the formulas that are showing the incorrect values from the dashboard? I would attempt this, then save the sheet and then open the dashboard in the same browser tab.

If that doesn’t resolve the issue, the best next step would be to open a ticket with our Support team so they can take a look at this specific sheet and dashboard and communicate with you via private channels. If you open a ticket, please provide them with these screenshots as well as the IDs of the sheet and dashboard (open the item and click File > Properties to find the ID).

Thanks,

Georgie

1 ·

Re: Pie Chart using aggregation and words in one of the columns

So I made a pie chart off of this data: to get the counts you can use a report and do a summary on the "type" OR you can use a countif formula. Do you need assistance with creating either of those?

State	3
Federal	3
Community	4

markkrebs

2 ·

Re: Creating a list based on checkbox columns

Here is an article that should help get you started:

https://help.smartsheet.com/learning-track/smartsheet-intermediate/reports

.

Paul Newcome

1 ·

Re: If statement for if a due date is next month

https://sl.bing.net/j2rzn3EWBw

Marcela

1 ·

Re: If statement for if a due date is next month

Yes that is perfect!! Thank you so very much!!

Jess.Peace

1 ·

Re: I have earned the Smartsheet Automagician Badge but I am not able to claim it

@Rebeca S. That would explain it! I got the email today, thank you for the update!

Sarah k Jones

1 ·

Re: January Question of the Month - Join the conversation and receive a badge

Happy New Year! I have been working in Smartsheet for a little over 5 years now and loving it. I enjoyed my time in Engage 2024 and am looking forward to attending in the future.

Now for my bucket list items:

Professionally, I would love to present at a Smartsheet User Group or Engage event in the future. I'm not sure what's on yet, but I love preparing and presenting to others how Smartsheet has benefitted me in my work and collaboration with others.

Personally - I have a few artists/bands I want to see that I have not had the chance to yet. It's a small but modest list that includes Stevie Wonder, PJ Harvey, and Rihana.

melissa.garcia

1 ·

Re: If statement for if a due date is next month

Hello @Jess.Peace

You are getting #UNPARSEABLE because Smartsheet does not support the EOMONTH function.

You can modify your formula to include a condition that checks if the [Due date] falls within the next month. Here’s your updated formula:

=IF(ISBLANK([Due Date]@row), " ", IF([Due Date]@row < TODAY(), "Late", IF([Due Date]@row = TODAY(), "Today", IF([Due Date]@row < TODAY(5), "This Week", IF(AND(MONTH([Due Date]@row) = MONTH(TODAY()), YEAR([Due Date]@row) = YEAR(TODAY())), "This Month", IF(AND(MONTH([Due Date]@row) = MONTH(TODAY()) + 1, YEAR([Due Date]@row) = YEAR(TODAY())), "Next Month", "Future"))))))

How it works:

Checks if [Due date] is blank, returns " " if so.
If [Due date] is before today, returns "Late".
If [Due date] is today, returns "Today".
If [Due date] is within 5 days, returns "This Week".
If [Due date] is in the current month, returns "This Month".
New Condition: If [Due date] is in next month (same year), returns "Next Month".
If none of the above apply, it defaults to "Future".

It woked for me as you can see in the image.

Hope this helps!

Marcela

2 ·