Best Of

Re: Counting formula-checked check boxes in sheet summary column - returns Invalid Data type

In your At Risk column, are there any cells that show "Invalid Data Type"? I just discovered that if a row in the At Risk column has "Invalid Data Type", that also gets sent to the Summary Field.

bisaacs

1 ·

Re: How to calculate using a 7 day workweek (to replace NETWORKDAY)?

Hey @Kathy PPT,

You should just be able to use NETDAYS(), as that counts every day between two dates.

Hope this helps!

bisaacs

1 ·

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

2 ·

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.

https://help.smartsheet.com/articles/2482078-build-a-row-report-with-report-builder#toc-create-a-row-report

Will this work for you?

Kelly

Kelly Moore

1 ·

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

1 ·

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.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Paul Newcome

1 ·

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

1 ·

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