-
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…
-
Dynamic View - Unable to update
Hello- I have a team working with the dynamic view to do their work. In the view, they said that under the email fields that they are not able to override/change the email address that was put in from the original form. I cannot see anything that would keep them being able to and when I put a test example in, I don't have…
-
Project Health Formula
Hey guys! I am facing some difficulty to get a formula for the logic below: Green Actual Start Date is blank AND Today () < Target Start Date Actual Start Date < Target Start Date AND status “in progress” Yellow Target End Date – Actual End Date >=0.1 * Duration planned AND Target End Date – End Date <=0.3 * Duration…