Best Of
Re: Dashboard width
@Kirstine - this enhancement is now available via Smartsheet EAP. However, some of the features are released based on plan-type or to organizations that have opted their entire org into the program.
Linda Manduchova
Re: How to Track Child (Level 2) Completed Rows Over Time?
Hey @Curculese
You will need a helper column to convert the dates in months, so that the data can be collected easily by month. If you plan to span years with the same graph, you might want to consider adding a Year portion to this data.
For month only, create a text/number helper column and use this formula
=MONTH([your completed date]@row)
If you wish to also combine the year with that so you can easily span years, consider using this formula
=YEAR([your completed date]@row)+"-"+MONTH([your completed date]@row)
Once you have the data in a sheet, you can create a report. You will bring in the Helper column as one of the report columns. Filter so that the report filters for your Level 2 rows. Group by your Helper column. Summarize (count) the helper column. You can then use this report as the source for your dashboard graph. Your data will be evergreen always.
Will this work for you?
Kelly
Kelly Moore
Re: Can I hide a row once a status is marked as complete in a column using conditional formatting?
You can via filters but it doesn't have the functionality like Excel. The filter would be to exclude anything in Status that says Closed.
One thing I did for this same need is just have those rows moved to an identical sheet so it captured the data and had the formulas removed. Reason for this is that certain look up information changes at times and I wanted to keep the original data that particular row/s had when it was completed.
Amanda Carta
Re: Conditional formatting change status with colors
You would use Conditional Formatting to adjust the cell fill color based on the status. That would be the button to the right of the paint roller in the top toolbar.
Paul Newcome
Re: Formula for business days?
Hey @laura.sandoval,
You can use IFERROR for that. It'd look something like this:
=IFERROR(NETWORKDAY(5/5/24, 5/10/24), "")
Hope this helps!
bisaacs
The new unified share button is now live for all customers!
Hi Community,
We're excited to share that all customers now have access to the new streamlined share UI experience that prioritizes one primary Share button in Smartsheet. Our goal with the redesign of the sharing experience was to help drive collaboration and make it easier to share your work. We have updated the primary share CTA in sheets to be easier to find, and we’ve made it easier to share full solutions instead of individual sheets and reports when appropriate.
Specifically, we are:
- We are introducing a drop-down menu under the share button. If the user is shared to both the workspace and the asset, they can select and share either the whole workspace or just the specific asset.
- We are removing the share button in the solution panel.
- We are removing the share to workspace button currently in the share modal.
All users are eligible to use the capability
Click the sharing icon in the upper right hand corner to experience the new sharing interface
If you have any questions about sharing please check out our updated help article.
You can also stay informed by Subscribe to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a weekly email with news of what's released every Tuesday.
Cheers to collaboration and transparency and our new enhanced sharing experience!
Elektra Helde | She/Her | Product Marketing
elektra_h
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
@brianschmidt terrific! Thanks for the detailed clarification on what does and doesn’t show up under those conditions! Very helpful indeed!
Will Jeffords
Re: Introduce yourself & get to know your peers!
Hi @Rebeca S.
Thank you for sharing these resources. There are many interesting webinars and more.
Best regards
Nicolas Goulinet
Re: What is the longest formula you've created?
I once had to create a dashboard to help myself not forget how I created one of the most complicated formulas I ever needed. I’m sure there are more elegant ways to do what I needed, but I ended up with this to help create Deferred Revenue tools and metrics for financial modeling…this us fairly nutso, but maybe will provide some of you some chuckles :)
Will Jeffords
Re: IF THEN statement
Hi @PMOGal,
Try doing it at the row level and see if that gets what you want.
=IF(AND(Finish@row < TODAY(), Status@row <> "Complete", Health@row <> ""), "Yes", "No")
Hope this helps,
Dave
DKazatsky2
