Best Of

Re: Character Limit on Emailed Notifications

Hi A.J,

It seems your email body exceeds 2000 character limit. This leads to "message truncated due to length" warning.

Try to create a helper column "Count" in your sheet to count the characters of all field you want to add in the workflow. Then in the workflow, you will check the condition : If Count < 2000 then send all fields, else send fields in 2 seperate emails.

Hope this works for you.

Gia Thinh

1 ·

Re: Aderant integrations

Hi @Trish Dillon

Since Smartsheet doesn't have a direct integration with Aderant, you could potentially use a third party application (similar to Zapier) or the Smartsheet API.

You may want to reach out to Aderant Support regarding what's required for integration from their side.

Cheers,

Genevieve

Genevieve P.

1 ·

Re: Help with Formula to Capture Dates for Full 12 Months

@Tina Ciak

Make 3 helper columns that simplify your formula:

Start Year: =YEAR([Start Date]@row)
Start Month =MONTH([Start Date]@row)
Start Day =DAY([Start Date]@row)

then your formula for each of the months is the below, replacing the bolded numbers with the corresponding month (e.g. April would be 4)

=DATE(IF([Start Month]@row > 1, [Start Year]@row + 1, [Start Year]@row), 1, [Start Day]@row)

Leibel S

1 ·

Re: Celebrating the Community with Smartsheet Swag!

Hello all, that link that was shared to the merch store earlier in this thread is internal and for Smartsheet employees only. Sorry for the confusion, though we of course think of our members as part of the SMAR fam! Good news is that we have plenty of swag plans coming on Community, including this one for Seekers, Contributors and Counselors. Get your forms in, and more to come. 💙

Alison C.

2 ·

Re: Is there an easy way to build a report with same order of columns.

This sounds like it would be a great item to submit to the Product Idea page on the Community. I’ve also created many Reports, and like yourself, often struggle when the list of columns is sorted alphabetically instead of the way I’ve intentionally ordered them in a sheet. I don’t think there’s a workaround for us (other than pulling up the underlying sheet on one monitor and building your report on another, which still requires you choose the lesser of the two evils you describe in your original post).

Lauren Dominique

1 ·

Re: RYG Formula and Status Question - almost there

Hi @johnna.young,

I think this will do what you're after:

=IF(Status@row = "Complete", "Gray", IF(AND(OR(Status@row = "At Risk", Status@row = "In Progress"), [Target End Date]@row >= TODAY(15)), "Green", IF(AND(OR(Status@row = "At Risk", Status@row = "In Progress"), [Target End Date]@row >= TODAY(4)), "Yellow", IF(AND(OR(Status@row = "At Risk", Status@row = "In Progress"), [Target End Date]@row <= TODAY(3)), "Red", ""))))

Sample: