-
3 condition formula- Help
Need help with a formula, 3 conditions- 1) Recognize first 3 digits of "ticket number" (EX: "LEG", "ONB", "REV") 2) Recognize when a task is past due 3) Status not "Complete" or "Not Applicable" What I have so far: =COUNTIFS({KIM- Project Plan- TEST Range 3}, "LEG", {KIM- Project Plan- TEST Range 1}, >TODAY(), {KIM-…
-
Delete and Lock row
Dear All I would like to know. Is it possible, if I want my team can edit the row but they can't delete it?
-
Multiply cell by 2 if checkbox is checked
Hey Smartsheet users! I've read through a lot of check and IF formulas and haven't been able to find my answer so here is the situation. This is for a mileage reimbursement form. I have a column titled "Mileage" and another column titled "roundtrip" the Roundtrip column is a checkbox column. See picture for what I'm trying…
-
Need help with formula to automatically fill in Contact List from another column
Hello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) All Staff (Contact List selector (assigned to)) Sheet 2 (reference Sheet) Technician Name - Contains full name Email Address -…
-
Creating a chart from non numeric values
I have created a form for users to fill out based on their experiences with a certain process. They will be asked questions such as "were instructions clear" and they can answer Very Clear, Somewhat Clear, Unclear. I was trying to create a pie chart from this sheet that shows how many users selected Very Clear vs. Somewhat…
-
How to show a "Completion Status" column based off of certain cells containing value?
Hello Smartsheet community, I have a database containing the amount of training specific employees have received. I would like to create a formula that is able to recognize what level someone is at and then the training needed for that level. If they have received the training it would show as "complete." If they have not…
-
Dashboards on mobile devices (tablets, phones) have poor performance.
There were issues with dashboard performance being reported last week (July 7th) and the Smartsheets dev team posted that they fixed it the same day but I am having severe performance issues on mobile devices still. The dashboards on our desktops are slightly slower than they were before but not disruptive. However, the…
-
Is anyone facing issue with the new Smartsheet dashboards?
Hi Everyone, The new dashboard is not working for us. It is taking ages to load (let alone edit). Is anyone else facing similar issues? Regards, Abhiraj Joshi
-
SalesForce connector to Smartsheet Filter records Does Not allow 'OR' only 'AND'?
SalesForce connector only allows for Filtering Operator 'AND' and Not 'OR', why is this case and what is a workaround for a scenario. Type ID: Not Equal to 'ABC' OR Type ID: Not Equal to 'XYZ' ?
-
Workspace Branding Appears Small & Blurry
I have more than one workspace in Smartsheet, one that I created and one that I am an admin for but not an owner. The workspace that I am an admin for has a large, clear brand at the top of the sheets and forms, but when I try to change the logo on the second workspace that I own, it comes out small with blurred edges. I…