Community member since October 2018
I specialize in document recognition and automation. We just use Smartsheet to track our work!
Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ?
Providing an example below for more clarity -
Lets say we break the client engagement (an enquiry -- lead generation -- service
I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas.
I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want
Has anyone noticed that Cloudflare is blocking people trying to access smartsheet.com lately? what's up with this new policy?
It also is doing it on the forums every time you try to add an image now.
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
I've created conditional formatting rules that are not working. They work if I set the rule to "is not equal to" but when I set them to "is equal to" they stop working. The spreadsheet contains "#NO MATCH" cells automatically formatted from another sheet. I want the "#NO MATCH" cells to
I've seen a few ideas on similar topic threads but none of them worked quite right, so I'm trying again!
I have a form staff fill out to record their overtime and the reason for it. Does anyone have any formulas that I can use to populate a column showing the numbers of hours:minutes of overtime
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 fields. (It basically builds a unique name for each of our customer audits) and looks like this..
Can someone show me how to use a VLOOKUP for the highest value?
=VLOOKUP(LARGE([% of Target]1:[% of Target]16, 3), Name1:[% of Target]16, 2)
Basically by the LARGE([% of Target]1:[% of Target]16, 3) I am returning a value of 52% (which is the third highest value). This is automatic.