-
Report Enhancement Request
I would like to be able to reference filter criteria for reports from a single top level cell. My project and workaround/issue is below: I am in the manufacturing business. We have machining lines that have a number of operations: ill say on average its ~20 operations. Each operation has an operator that at the end of the…
-
IF/OR/And
Hello! I am trying to add a formula to do the following: - count if something is chosen in a drop box column ("Rentleving Toolbox") AND also count IF something is chosen in the drop box column also marked as "Central" in the "Region" Column. Any help here?! I've been trying various versions of this: =SUMIFS([Rentleveling…
-
Dashboard quirks?
Hey all, I am evaluating smartsheet for my company. I have looked around the support areas and not finding an answer to my observations/question. So, I create a project sheet with tasks and milestones, no problem! When I create a report and add a Dashboard widget, 2 issues(?). The time-now line on the Gantt view does not…
-
Contact Column Enhancement Request
1. Please allow me to at least use an if statement for contact columns. 2. It would be nice to be able to reference 2 emails, either / person or even /cell. 3. Please allow for a phone number to be associated to a person in the cell. I want to send texts, and I know I can send a text via email, but if their email is…
-
Question re: image attachments when using Smartsheet for Outlook Add-in
I use the add-in and whenever i am moving an email to Smartsheet, it automatically selects all images in addition to any PDF or other attachment. My signature line contains 6 images and so every time i add something through the add-in, it tries to pull these same 6 images. I must de-select them each time. So here's the…
-
Shift license and owned sheet at same time to new user
I have 6 licenses and 6 licensee's and want to transfer a license to a new person from a current person and transfer the owned sheets to the new person. Problem is that the license needs to exist with the new person to give the sheets to that person, but i can't give them the license until i move the owned sheets. I hate…
-
Working Days
Hello, I am trying to set conditional formatting to highlight due date cells when it is within 3 working days, however the sheet counts Saturday and Sunday as days. Is there anyway of setting the sheet so saturday & sunday do not count as days?
-
Signatures on Forms
I was wondering if there was a function that I could you use to sign forms? I have staff of about 80 who need to sign that they have received Tools of Trade like mobiles. At the moment we are doing this with paper, which gets lost - would love to be able to set up a smart sheet and have everyone saved in the same place and…
-
How to pass the Product Certified User Exam?
Hello smartsheet Community! I have taken all of the eAcademy classes, but am having trouble passing the Product Certified User Exam. Do you have any suggestions on how I can be successful in the future? Many thanks, --Suzy
-
Automate RYG Balls
Hello! I am trying to automate the cells so that when a specific value is entered, it will return a colored ball in the same cell Example: 0 = Red ball, .6= Yellow Ball, 1= Green Ball and 0%-30%= Red, 31%-70% = Yellow, 71%-99% = Green, 100% = Gray Can you please let me know how I can achieve this? Thank you
