-
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.…
-
How to input a date/time and calculate a time elapsed?
I'm brand-spanking new to Smartsheet. We are trialing it for work and I'm trying to convert some of my Excel workbooks for use in this new platform. A really common formula for my work is =(Time1-Time2)*1440 which gives me a total time elapsed in minutes. I then build my dashboards to take those calculated fields and do…