Best Of

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 ·

Re: Need a formula that evaluates multiple cells for data

so I'd add a Helper column with a column formula of =JOIN([Event Name - EN]@row:[Event Name - SP]@row)

just to make the index match formula easier. One issue is if someone inserts a column between those columns. If thats a concern we could do a longer formula in the lookup. So the Lookup formula would be

=index({return value ref},match(Helper@row,{matching column ref},0))