-
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…
-
Support is not responding - Our form submissions are not working
Since Monday (6/14/2021) we have not been able to submit forms to our critical sheet. I have 3 cases with smartsheet and they have not responded. Does anyone have a more direct way to get in touch with support? Case number: 04735933 Case number: 04738520 Case number: 04741529
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…
