J. Craig Williams’s Profile

Community member since November 2015

points
23422
How I Use Smartsheet
Daily tasks, any around the house or longer than a few days projects, project management, resource management.
About Me
Smartsheet Certified User

See:
https://ronin-global.com/contact-us-smartsheet-help/
to see info about me or how to contact me.
The password is "thankyou"

Also I have posted tips and tricks for Smartsheet here:
https://ronin-global.com/category/smartsheet-help/

1

Title says most of it, so I'll repeat it:

Bug or Feature?: Used in Formula does not display for Contact List

Hover over the [ContactList] column which is referenced by formula on the destination sheet does not ever display the "Used in Formula ... " pop-up.

I did not see anything in the Help

5

I am trying to do a =SUMIF into a sheet via cross reference (=SUMIF({Mth/Yr}, ={Prev Yr Mth/Yr}, {DofC NN.NN}))

Mth/Yr = 9-2019

Prev Yr Mth/Yr = 9/2019

DofC NN.NN contains rows that have a value with 0.nn (nn = 01 thru 99)

The result from the SUMIF is 0 (zero)

Does SS not add values with leading

2

How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is changed to not bidding then I would like for it to move to

3

Hello,

Is anyone else disappointed in the pricing and the lack of availability of the Smartsheet Addons/Premium Features? 

The features of these premium addons are pretty badass and would be useful. I feel like I would use dynamic reporting (especially if they had date filters) quite a bit. Along

5

Oh COME ON!

Why why would you change a keyboard shortcut?

Are you aware of muscle memory?

This just sadistic.

Isn't this one of the golden rules of hot-keys? 

They don't need to "make sense" and you shouldn't need to or ever really be able to guess them.

WHAT COULD POSSIBLY BE THE REASON TO CHANGE

4

Ugh my formula's wrong and it's spread out over 100 files.  It was bad enough going back and entering the formula across all sheets the first time now I'm going to have to redo it.  Is there any user define function available that might make this easier to update?  I can understand that UDFs might