-
Why is my formula unparseable?
=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A") The bold is what I want to subtract within the formula.
-
Smartsheet Application Zoom Function
Smartsheets does not support browser zoom levels under 90% and begins to misalign rows, columns, dashboard widgets and more. This is still an issue within the smartsheet application and continues to shift and misalign data and widgets. Specifically building a dash board is very challenging as the alignment tools made to…
-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…
-
Sharepoint site refused to connect in work apps
Hello , this embed SharePoint page stop working last week. I don't have any issue accessing the SharePoint original page. I guess this issue is related to Smartsheet workapps application. Does anyone know what it could be?
-
Repeating Data
I have a sheet that pulls information from a master sheet to keep track of dates. 3 columns are repeating data and have been for a few days now. Is there a problem with the formula? I have seen this happen before, but signing out and back in a day later, it usually fixes itself. This time, it has just shown the same value…
-
How do I get the Credly badge to display on my profile?
I got Core Product Certified about a month ago at ENGAGE. However, I did not receive an email with a Credly badge like I did for the Core App self paced learning. I also haven't received the badge here on Smartsheet Community. I'm not sure if this is an issue because I took the certification exam in person, but I'd love to…
-
NEED IMMEDIATE HELP ON A DASHBOARD ISSUE!
Can someone please help me overcome this strange issue in Smartsheet dashboards? I can't show it to my clients! The dashboards should be intelligent enough to display a clean arrangement! Further, we can't even reduce the point-size of these numbers... above each bar. PLEASE RESOLVE IT AS I MIGHT LOSE BUSINESS DUE TO THIS…
-
Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
-
How to recreate a payment month Excel formula in Smartsheet
Hoping you might be able to help me with migrating a formula from Excel into Smartsheet. I'm in the process of recreating a payment tracker solution for some colleagues of mine, but I'm struggling to replicate one of the formulas. The formula is as follows: =IF(DAY(C4)<=3,TEXT(C4,"yy-mm(mmm)"),TEXT(C4+30,"yy-mm(mmm)")) The…
-
Work App Page Permissions are locked
We are using control center to auto provision a project folder in a workspace and a work app for the project. The auto provisioning of the work app creates several roles, defaults users to those roles and adds pages with page permissions for each role. As the Work App Owner, I am trying to change the page permissions for…
