Best Of
Re: Increase the Latest Comment Column Character Limit
We're using the Latest Comments field in a customer-facing project artifact, and it would be so helpful to have this limit increased!
Rather than providing customers access to edit our sheet (and view internal-only items), I'm notifying them when certain triggers occur on the sheet. Latest Comment is one of the most important fields I include in the body of those notification emails. I'm trying to train my team, but currently, customers are receiving notification emails where the Latest Comments cut off, and it causes a great deal of confusion.
Please consider this improvement to a great feature!
Amy.Mizzi.RP
Re: Using full stops or commas for numbers
You can't force the user to use commas vs periods in the form directly, but what you can do is insert a helper column on the sheet and use a formula to swap any periods out for commas and convert it into a numerical value.
=VALUE(SUBSTITUTE(Spesa@row; "."; ","))
Paul Newcome
Re: Conditional count of parents rows only with now children on a date column.
Hi @Kingskid
You can filter out Child Rows as long as your source sheet has something that indicates if the row is a Child or Parent.
From what I can see in your screen capture, only Parent rows have a date in the "Date Logged" column, is that correct? If so, you can add criteria that says that cell needs to be <> "" or Not Blank:
=COUNTIFS({Date Logged Column}, <> "", {CC Label Activities}, AND(@cell >= DATE(year@row, [Month1]@row, 1), @cell <= DATE(year@row, [Month1]@row, 31)))
Cheers,
Genevieve
Genevieve P.
Re: Product Usage Badges - Celebrating our Power Users 🎉
Hi, @Salèha El D. love the enthusiasm! These badges celebrate great product use, so just keep on creating awesome Smartsheet solutions, and sharing with people in your organization. If you wish to share anything amazing you're doing with the Community, the Show & Tell topic is the place to go. 😄
Hi, @Monicacraven, we award the badges for Automagicians and Superstars once a month. If you've gotten an email notification, you'll be able to see it in your badge list soon!
Rebeca S.
Re: December Question of the Month 💭 Join the conversation and receive a badge
In terms of Smartsheet, I've designed a Work Order tracking and approval worksheet that seems to push the boundaries of what Smartsheet was intended for. I discovered this when I asked a tech about an email format generated from the sheet, and they mentioned it was an usual use of the product.
On a personal note, handling my partner's severe stroke aftermath has been challenging. It's sometimes more demanding than dealing with a teenager, but I've learned to stay calm and navigate through it all.
MMerin
Re: Can I auto-populate base on role in Smartsheet and sync with Resource Management?
There currently isn't a way to use a column formula in an Assigned To column and also have that column sync with Resource Management; the cells in that Assigned To column will need to be editable through the integration.
If you have access to DataMesh, I would potentially use DataMesh to bring in both your contacts and role into the second sheet, although this would require a new DataMesh workflow every time you have a new Sheet B.
Cheers,
Genevieve
Genevieve P.
Re: Smartsheet Modified at cell capturing on Log in issue
The column formula with the TODAY function is what is causing the updates. The TODAY function is updating on the back end to today's date when the sheet is activated for the first time each day.
Paul Newcome
Re: Formula for filtering multiple columns to get an expense total
The syntax of the SUMIFS function is as follows;
SUMIFS( range , criterion_range1 , criterion1 [ criterion_range2 , criterion2... ])
- range — The group of cells to sum, assuming they meet all criteria.
So, add "S" to your existing formula's SUMIF, move the EXPENSE8:EXPENSE1915 to the top as the range to sum, then add the 2nd criterion_range and criterion, ID8:ID1915, "RAD PODS," at the bottom.
=SUMIFS(EXPENSE8:EXPENSE1915, [VENDOR PERSON]8:[VENDOR PERSON]1915, NOTES@row, ID8:ID1915, "RAD PODS")
Re: "When rows are added" not triggering Update Request automation
Hi @FrankM
Can I assume that your trigger for the Alert is based on content being added, versus a cell being blank?
When DataShuttle updates a row, it adds content to specific cells in that row. Even though the row is "added", blank cells aren't seen as being added to the sheet since nothing changed for those cells.
I'd recommend setting up you Update Request workflow to be triggered on the column that will always contain data, and then have conditions that look for the blank values:
Let me know if this works for you!
Cheers,
Genevieve
Genevieve P.
Re: I want to use a formula to convert a date into a year and quarter
This is a great solution and was just what I was looking for! Just one note - in order to report quarters it needs a very slight adjustment:
="Q" + ROUNDUP((MONTH([Date]@row)/3)) + " " + YEAR([Date]@row)
Dividing the Month by 4 will result in your year being divided into thirds of four months each rather than quarters of three months each.
Jeff Kunkel