Best Of

Re: How to change date format in generated document

The column using the DATEONLY function is storing the original format on the back-end which is the format used when generating the PDF.

You will need a text/number column with a formula that outputs a text string that just looks like the date format you want.

=DAY([Created Date]@row) + "-" + IF(MONTH([Created Date]@row) = 1, "Jan", IF(MONTH([Created Date]@row) = 2, "Feb", IF(MONTH([Created Date]@row) = 3, "Mar", IF(MONTH([Created Date]@row) = 4, "Apr", IF(MONTH([Created Date]@row) = 5, "May", IF(MONTH([Created Date]@row) = 6, "Jun", IF(MONTH([Created Date]@row) = 7, "Jul", IF(MONTH([Created Date]@row) = 8, "Aug", IF(MONTH([Created Date]@row) = 9, "Sep", IF(MONTH([Created Date]@row) = 10, "Oct", IF(MONTH([Created Date]@row) = 11, "Nov", "Dec"))))))))))) + "-" + YEAR([Date Created]@row)

Paul Newcome

1 ·

Re: Syncing Smartsheet calender with Outlook

Hi, Is there solution to do the other way around which is syncing Outlook to Smartsheet Calender ? Meaning we send event invitation from Outlook to my Smartsheet Calender and update in my Smartsheet Calendar. Thanks

Alvin Ong

1 ·

Re: Display formula result in form

Hi @Ridac

I hope you're well and safe!

You could have an automated Alert trigger when the form is submitted, which can also include the information from column b.

Make sense?

Would 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å

1 ·

Re: Product Usage Badges - Celebrating our Power Users 🎉

https://community.smartsheet.com/discussion/comment/408741#Comment_408741

Hi @JHickey, happy to welcome you to the Smartsheet Community 😃

Love that goal, I'm sure you'll get these badges in the future! We have a variety of resources you can check out, and of course, you can ask your questions here in the Community, and read other members' questions to learn from them as well.

Rebeca S.

1 ·

Re: How To create a revenue summary formula

You would first need a helper column with a formula that outputs the dollar amount for a single month.

=(MONTH([End Date]@row) - MONTH([Start Date]@row)) + ((YEAR([End Date]@row) - YEAR([Start Date]@row)) * 12) + 1

Then you would use a SUMIFS to get the total amount for a single month from every row like so:

=SUMIFS([Helper Column]:[Helper Column], [Start Date]:[Start Date], AND(IFERROR(MONTH(@cell), 0) <= 6, IFERROR(YEAR(@cell), 0) >= 2023), [End Date]:[End Date], AND(IFERROR(MONTH(@cell), 0) >= 6, IFERROR(YEAR(@cell), 0) >= 2023))

The above is for June 2023. Adjust the 6s for the month you want to sum for and the 2023s for the years.

Paul Newcome

1 ·

Re: Automated copy from row to a new row in the same and single sheet.

@Romano el Polako You can use a helper sheet. What you will do is set up an automation to Copy the row to another sheet. On the helper sheet, you can then set up an automation to Move the row to the original sheet, thus creating a duplicate. If you need certain fields blank, you would also set up an automation for new sheets that changes certain cells to blank.

Hope that makes sense and helps you.

Eric Law

1 ·

Re: Is there a way to conditionally email scheduled reports (ex. only send when not blank)

Hi @Deb Schofield

I hope you're well and safe!

Unfortunately, it's not possible now to block the report if it's empty, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

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å

1 ·

Re: Source Sheet & Dynamic View Dates Don't Match

Hi @khickman

I hope you're well and safe!

You can add a so-called helper column and format the date with the predefined formats or create your own using formulas.

Would 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å

1 ·

Re: Dynamic dropdowns - Waterfall request

This would be incredibly helpful for us. I would be happy to just be able to reference a column in another sheet - just like you would do with a regular sheet reference to build out my applicable dropdown values. To have the ability to sort or not sort the list within the dropdown properties would be a 'nice to have'.