L_123
L_123
-
Re: A leading zero is disrupting my formula.
=(value([(H) Hour]1) * 60 * 60) + (value([(M) Minute]1) * 60) + value([(S) Second]1)1 · -
Re: How to get smallest, 2nd smallest value and 3rd smallest value
=small(collect(qty:qty,products:products,"Banana"),1) =small(collect(qty:qty,products:products,"Banana"),2) =small(collect(qty:qty,products:products,"Banana"),3)6 · -
Re: Can an Excel form be used to populate a sheet?
I've managed this in VBA before. If you are interested I can help you put your information from excel to smartsheet. The general concept behind it is On submission you save each item in vba to a vari…7 · -
Re: Onboarding new users in Smartsheet.
Generally for key users I have 2 trainings on separate days. The first training we go over standard functionality(read smartsheet heirarchy), navigation, and smartsheet basics. The second day we go t…1 · -
Re: How do I have a Dashboard show only 100% not 150%
You can use a helper column =if(percent@row>1,1,percent@row) and drag it down, then reference the helper column for the chart. Or you can use conditional logic to perform this right inside of your…1 ·
